Vlookup and #N/A

P

Pablo

I am doing a Vlookup and it is returning a #N/A when the reference value does
not exist. Is there function to convert the to " "? The reasoning is that
#N/A is kind of ugly and I have a couple other formulas testing for a " ".

Thanks,
 
G

Gord Dibben

Note the "" in Duke's formula.

Your " " creates a space character which could lead to problems.


Gord Dibben MS Excel MVP
 
Top