Vlookup when no value match

C

caroline

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
 
D

Duke Carey

versions prior to 2007

=IF(ISNA(vlookup formula),"No match",vlookup formula)

In 2007

=IFERROR(vlookup formula,"No match")
 
R

Ron Rosenfeld

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
Click to expand...

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
 
Top