Vlookup returns #N/A

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

 

[Dave Peterson]

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

In xl2007, you can use:
=iferror()

 

[John Moore]

or try
=if(iserror(yourlookupformula)),"0",(yourlookupformula))

 

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

 

[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