Vlookup question
 

Hello. Per the extremely helpful advice of a contributor last week, I
have created a table for a vlookup to reference. This table's range
is -100 to 100 and each number within that range is accompanied by a
color. For example, numbers 0 thru -100 are accompanied by green.
While my vlookup works for positive numbers (and returns the correct
color), I am having trouble getting it to work for negative numbers.
My current vlookup formula is =VLOOKUP(Z64, my color table, 2,
FALSE). All of my data columns are formatted the same way. Any idea
why I might be pulling N/A's for the negative numbers? Thanks!

Vlookup question
 

My current vlookup formula is =VLOOKUP(Z64, my color table, 2,
FALSE). All of my data columns are formatted the same way.

So, I assume your color table looks something like this:

-100...red
...-99...blue
...-98...yellow
......0...green
......1...green
..... 2...green
..100...green

If Z64 is a negative number your formula *should* work just fine. There's
nothing wrong with your formula.


--
Biff
Microsoft Excel MVP


wrote in message
...
Hello. Per the extremely helpful advice of a contributor last week, I
have created a table for a vlookup to reference. This table's range
is -100 to 100 and each number within that range is accompanied by a
color. For example, numbers 0 thru -100 are accompanied by green.
While my vlookup works for positive numbers (and returns the correct
color), I am having trouble getting it to work for negative numbers.
My current vlookup formula is =VLOOKUP(Z64, my color table, 2,
FALSE). All of my data columns are formatted the same way. Any idea
why I might be pulling N/A's for the negative numbers? Thanks!