How to make #NA appear blank?


B

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
 
Ad

Advertisements

J

JE McGimpsey

One way:

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

Advertisements

B

Boatman

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

Boatman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top