How to make #NA appear blank?

[Boatman]

In a long column of vlookup equations, some cells evaluate to #NA when the
table array does not contain the lookup variable. That's fine, but how do I
make those cells appear blank, or better yet, empty? I have tried
"=IF(VLOOKUP(C2,range2,10,FALSE)=NA(),"",VLOOKUP(C2,range2,10,FALSE))", but
this unexpectedly (to me) also evaluates to #NA.

Thank!

Boatman

[JE McGimpsey]

One way:

=IF(ISNA(VLOOKUP(C2,range2,10,FALSE)),"",VLOOKUP(C2,range2,10,FALSE))

In article <[email protected]>,
"Boatman" <[email protected]> wrote:

> In a long column of vlookup equations, some cells evaluate to #NA when the
> table array does not contain the lookup variable. That's fine, but how do I
> make those cells appear blank, or better yet, empty? I have tried
> "=IF(VLOOKUP(C2,range2,10,FALSE)=NA(),"",VLOOKUP(C2,range2,10,FALSE))", but
> this unexpectedly (to me) also evaluates to #NA.
>
> Thank!
>
> Boatman

[Boatman]

That worked great. I just pasted it in as you wrote it. Thanks!

Boatman


"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> One way:
>
> =IF(ISNA(VLOOKUP(C2,range2,10,FALSE)),"",VLOOKUP(C2,range2,10,FALSE))
>
> In article <[email protected]>,
> "Boatman" <[email protected]> wrote:
>
>> In a long column of vlookup equations, some cells evaluate to #NA when
>> the
>> table array does not contain the lookup variable. That's fine, but how do
>> I
>> make those cells appear blank, or better yet, empty? I have tried
>> "=IF(VLOOKUP(C2,range2,10,FALSE)=NA(),"",VLOOKUP(C2,range2,10,FALSE))",
>> but
>> this unexpectedly (to me) also evaluates to #NA.
>>
>> Thank!
>>
>> Boatman