Vlookup result change

G

Guest

Hi, when I run my Vlookup it returns NA# as a result for some cells. Is there
a way for me to have the na# displayed as a text for example “check date†or
just leave those cells containing na blank.
THANKS.
 
G

Guest

=IF(ISNA(VLOOKUP(your current formula)),"check date",VLOOKUP(your current
formula))
Bob Umlas
Excel MVP
 

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

Converting Text 9
VLOOKUP 4
How do I count # of cells with same value other column? 4
How do I avoid #NA result in a VLOOKUP 8
how to count#cells w/= value in other column and not count blank c 4
why this strange result with vlookup 2
Vlookup command not giving the correct result 2
Vlookup in Excel 2003 2

Top