ISNA VLOOKUP INDIRECT combination does not work

ct00010

New Member
Joined
Oct 22, 2019
Messages
9
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
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
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
Joined
Oct 22, 2019
Messages
9
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
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
My pleasure & thanks for the feedback
 

ct00010

New Member
Joined
Oct 22, 2019
Messages
9
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
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
As this is now a different question, you will need to start a new thread.
Thanks
 

Forum statistics

Threads
1,078,213
Messages
5,338,891
Members
399,265
Latest member
aj17x55

Some videos you may like

This Week's Hot Topics

Top