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