VLOOKUP Error

E

evoxfan

In a column I have Vlookup formulas. Some have an error "#N/A" if it can't
find the data it is looking for.

Is it possible to show a blank instead of "#N/A" when the formula does not
find what it is looking for?

Thanks in advance.
 
B

Burnnie Holliday

Try this:

=IF(ISERROR([insert VLOOKUP formula here]), "", [insert same VLOOKUP formula
here])
 
G

Gord Dibben

=IF(ISNA(VLOOKUP(G1,$A$1:$F$31,2,FALSE)),"",VLOOKUP(G1,$A$1:$F$31,2,FALSE))

Best not to use ISERROR because that will mask all errors, not just #N/A


Gord Dibben MS Excel MVP
 
T

T. Valko

Another possibility:

Let's assume your lookup formula is:

=VLOOKUP(A1,B1:C10,2,0)

=IF(COUNTIF(B1:B10,A1),VLOOKUP(A1,B1:C10,2,0),"")
 
Top