getting #N/A when vlookup is a negative number
 

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.

getting #N/A when vlookup is a negative number
 

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.

getting #N/A when vlookup is a negative number
 

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.

getting #N/A when vlookup is a negative number
 

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.