Vlookup result change

D

DP7

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.
 
B

Bob Umlas, Excel MVP

=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
If Vlookup is error ( #NA) 5
why this strange result with vlookup 2
VLOOKUP text vs number issues returning value 13
How do I avoid #NA result in a VLOOKUP 8
VLOOKUP 4
Vlookup Problem 7
how to convert #na to 0 when using vlookup 2

Top