#N/A error in Vlookup

[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

 

[Bob Phillips]

John,

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

or for more generic errors, replace ISNA wiuth ISERROR.

 

[Laura Cook]

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))