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.