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
 
Top