getting #N/A when vlookup is a negative number

[Rick B]

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.

 

[Glenn]

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.

 

[Gord Dibben]

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

 

[Chip Pearson]

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