#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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help vlookup? 3
Need VLOOKUP to Work Two Ways 0
VLOOKUP Error 4
Remove #N/A Error 3
Vlookup - N/A 4
VLOOKUP Problem 1
IF/VLOOKUP with #N/A results 6
VLookup Function HELP 7

Back
Top