Hi
I'm trying to use INDIRECT to go to a particular sheet check a cell for particular text, if it contains that text, do nothing, if it contains something else then display that text.
I've tried several variations on a theme:
=IF(INDIRECT("'"&$A3&"'!$M$4="Please Select"," "),MATCH(INDIRECT("'"&$A3&"'!$M$4"))
and
=INDEX(INDIRECT("'"&$A3&"'!$M$4"),MATCH(D$2,INDIRECT("'"&$A3&"'!$C$7:$N$7"),0))
for example but I keep getting the same error at "Please
Any ideas please?
Kind regards
DezB