ISNA VLOOKUP INDIRECT combination does not work

ct00010

New Member
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:
https://filebin.net/p7vwo1260xbkgean

Please could someone help me solve this its really annoying me.

Fluff

MrExcel MVP, Moderator
Hi & welcome to MrExcel.
Is this what you need in C4 copied down & across
=(IF(ISNA(VLOOKUP(C\$3&"*",INDIRECT("'"&"*"&\$B4&"*"&"'!\$A:\$A"),1,0)),"NO","YES"))

ct00010

New Member
Hi & welcome to MrExcel.
Is this what you need in C4 copied down & across
=(IF(ISNA(VLOOKUP(C\$3&"*",INDIRECT("'"&"*"&\$B4&"*"&"'!\$A:\$A"),1,0)),"NO","YES"))
Hi Hero Fluff!

Thank you for the warm welcome.

Also, thank you soo much for the solution. What a Hero!

Thank you sir!

Fluff

MrExcel MVP, Moderator
My pleasure & thanks for the feedback

ct00010

New Member
Would it be possible to replace the 1 from the formula to a match function? like the formula below:

=(VLOOKUP(C\$3&"*",INDIRECT("'"&"*"&\$B4&"*"&"'!\$A:\$Z"),MATCH("Price",0)

I cannot work out a way to return a value when a the price column are situated in different column letters and tabs across the workbook.

Is there a solution to this formula please?

Fluff

MrExcel MVP, Moderator
As this is now a different question, you will need to start a new thread.
Thanks