Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup result change
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup result change
=IF(ISNA(VLOOKUP(your current formula)),"check date",VLOOKUP(your current
formula)) Bob Umlas Excel MVP "DP7" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
VLOOKUP - Can't see result | Excel Worksheet Functions | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
vlookup returning a n/a result | Excel Worksheet Functions | |||
Determning the ROW of a vlookup result | Excel Worksheet Functions |