Vlookup and #N/A
 

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,

Vlookup and #N/A
 

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

"Pablo" wrote:

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,

Vlookup and #N/A
 

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

"Duke Carey" wrote:

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

"Pablo" wrote:

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,

Vlookup and #N/A
 

Note the "" in Duke's formula.

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


Gord Dibben MS Excel MVP

On Thu, 9 Aug 2007 10:32:10 -0700, Pablo
wrote:

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

"Duke Carey" wrote:

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

"Pablo" wrote:

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,