Lookup function wont ignore blank cells

=if(iserror(index(sheet2!B1:B65536,match(c5,sheet2!B1:B65536,0))),"No","Yes"),

Click to expand...

Kquig said:

Any help on this would be much appreciated.

I've tried many didn't formulas however I keep returning to:

=IF(ISNA(VLOOKUP(C5,Sheet2!B:B,1,FALSE)),"YES","NO")

In the 'C' column on sheet 1 zip codes will be entered, on sheet 2, column 'B' is a list of zip codes. This formula states a 'YES' if the zip code is not found and a 'NO' if it is. The problem with it is if the 'C' column is blank it shows the 'YES' answer, which I don't want.

Is there a change I can make to the formula to have it show no answer if the 'C' cell is blank?

Thank you so very much in advance, I'm pulling my hair out trying to get this to work properly.

Click to expand...

=IF(ISBLANK(C5),"",IF(ISNA(VLOOKUP(C5,Sheet2!B:B,1,FALSE)),"YES","NO"))

JoeMo said:

Maybe:

Code:

=IF(ISBLANK(C5),"",IF(ISNA(VLOOKUP(C5,Sheet2!B:B,1,FALSE)),"YES","NO"))

Click to expand...