Vlookup and #N/A

[Guest]

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,

 

[Guest]

=if(isna(your vlookup goes here),"",your vlookup goes here again)

 

[Guest]

Thanks. I guess the TRUE or FALSE kept throwing me off.

 

[Gord Dibben]

Note the "" in Duke's formula.

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


Gord Dibben MS Excel MVP