Vlookup returns #N/A

J

Joe M.

When a match can't be found I get #N/A. I would like the results to be blank
if there's no match. Can you help?
 
D

Dave Peterson

=if(isna(yourvlookupformula),"",yourvlookupformula)

In xl2007, you can use:
=iferror()
 
D

Dave Peterson

Usually when I want a 0 returned, I want it as a real number--not text.

I'd use:
=if(iserror(yourlookupformula)),0,(yourlookupformula))
(w/o the double quotes)

But in this case, the user wanted a cell that would look blank.
 
G

Gord Dibben

I suggest not using the iserror function which could mask errors other than the
#N/A

My 2 cents added.


Gord Dibben MS Excel MVP
 
Top