ISNA VLOOKUP INDIRECT combination does not work

[ct00010]

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]

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]

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]

My pleasure & thanks for the feedback

 

[ct00010]

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]

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

 

[ct00010]

Hi Fluff,

Ok thank you much I have started a new thread for this as requested:

https://www.mrexcel.com/forum/excel...ndirect-match-function-error.html#post5364555

Thank you very much.

CT