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

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top