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.

Rick B 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.



Post your current formula.

If you don't have that particular negative number in the table you will get
the error.

If the number exists, should be no problem.

Post your formula and a sample of your data table.


Gord Dibben MS Excel MVP

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.

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.