Hi all,
I'm having trouble with the following formula below:
=IF(ISNA(VLOOKUP($C$3,INDIRECT("'"&"*"&$B4&"*"&"'!$A:$A"),1,0)),"NO","YES"))
The indirect function does not seem to work with the vlookup or I am doing it wrong.
Please see below for the excel file...