| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup when no value match
Hello,
I am trying to find if a value exists in a list. However, I need the result of the Vlookup to give me a meaningfull value(Not #NA) if Vlookup is unsuccessful in finding a match, as I am using this value for a IF statement. Any idea? Thanks -- caroline |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup when no value match
versions prior to 2007
=IF(ISNA(vlookup formula),"No match",vlookup formula) In 2007 =IFERROR(vlookup formula,"No match") "caroline" wrote: Hello, I am trying to find if a value exists in a list. However, I need the result of the Vlookup to give me a meaningfull value(Not #NA) if Vlookup is unsuccessful in finding a match, as I am using this value for a IF statement. Any idea? Thanks -- caroline |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup when no value match
On Tue, 14 Aug 2007 04:20:03 -0700, caroline
wrote: Hello, I am trying to find if a value exists in a list. However, I need the result of the Vlookup to give me a meaningfull value(Not #NA) if Vlookup is unsuccessful in finding a match, as I am using this value for a IF statement. Any idea? Thanks How do you define a "meaningful value"? #NA has a meaning -- it means there was no exact match! If you want some other value, just use an IF formula to output what you want when VLOOKUP outputs #NA. =IF(ISNA(your_formula),"meaningful value", your_formula) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
| vlookup to match | Excel Discussion (Misc queries) | |||
| vlookup, match? what do I use? | Excel Worksheet Functions | |||
| Vlookup and Match | Excel Discussion (Misc queries) | |||
| vlookup - Best match? | Excel Discussion (Misc queries) | |||
Linear Mode
