Are you looking for an exact match or a closest match? If you're
looking for an exact match, you need to include the last parameter to
VLOOKUP as FALSE:

=VLOOKUP(A1,B1:C20,2,FALSE)

If you omit the FALSE (or use TRUE), then the lookup list data must be
in ascending sorted order. If it isn't sorted, VLOOKUP won't return
the result you expect.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Fri, 21 Aug 2009 13:14:01 -0700, Rick B <Rick
wrote:

When I do a vlookup and the lookup value is a negative number and negative
numbers are in the lookup table I get a #N/A instead of the negative number I
am looking for.