VLOOKUP Error

[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.

 

[Burnnie Holliday]

Try this:

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

 

[Teethless mama]

=IF(ISNA(your_formula),"",your_formula)

 

[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. 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),"")