#N/A error in Vlookup

  • Thread starter Thread starter John Kramer
  • Start date Start date
J

John Kramer

I have a sheet that lookes at data in another sheet. It
looks at the zip codes of the sheet and finds the match
then puts in the value from the 3rd column over. The
problem is that if the data doesn't have a matching zip
code I get a #N/A error. I'm trying to find the formula
that will leave it blank. I've used on some workbooks
like isblank and such. What can I use so if there is no
match it will be blank.

John
 
John,

Use
=IF(ISNA(lookup_formula),"",lookup_formula)

or for more generic errors, replace ISNA wiuth ISERROR.
 
Replace your VLOOKUP formula with the one I have inserted twice in the
formula below:

=IF(ISNA(VLOOKUP(A1,Sheet1!E1:G20,3,0)),"",VLOOK
UP(A1,Sheet1!E1:G20,3,0))
 
Back
Top