Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup question
If the item I'm looking up doesn't exist in the range, is there a way to
return blank (or ""), instead of N/A? Any help is greatly appreciated. Thank You! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup question
Hi,
Yes: =IF(ISNA(vlookup_formula),"",vlookup_formula) Cheers! Jean-Guy "HROBERTSON" wrote: If the item I'm looking up doesn't exist in the range, is there a way to return blank (or ""), instead of N/A? Any help is greatly appreciated. Thank You! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup question
=IF(ISERROR(VLOOKUP([your vlookup]),"",VLOOKUP([your vlookup]))
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "HROBERTSON" wrote: If the item I'm looking up doesn't exist in the range, is there a way to return blank (or ""), instead of N/A? Any help is greatly appreciated. Thank You! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP question | Excel Worksheet Functions | |||
Vlookup question | Excel Discussion (Misc queries) | |||
VLOOKUP question | Excel Worksheet Functions | |||
vlookup question | Excel Worksheet Functions | |||
Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) |