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.

Thanks in advance!
 

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!
 

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
 

Some videos you may like

This Week's Hot Topics

Top