Vlookup when no value match

[Guest]

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

 

[Guest]

versions prior to 2007

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

In 2007

=IFERROR(vlookup formula,"No match")

 

[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

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