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
 
J

JE McGimpsey

One way:

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

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

Similar Threads

Quantity Blank, Remaining cells in row appear Blank 8
Vlookup Match BUT Returning #NA 1
Vlookup returning NA when referencing cell data to another sheet 2
#NA 11
#NA error when doing a look up 1
Use array for lookup value, to return array of lookups 4
help to in setting up a proper Vlookup table and formula 4
How can Excel make a cell empty without making it na()? 1

Top