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