Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF/AND VLOOKUP question... | Excel Discussion (Misc queries) | |||
VLOOKUP question | Excel Discussion (Misc queries) | |||
VLOOKUP question | Excel Discussion (Misc queries) | |||
vlookup question | Excel Discussion (Misc queries) | |||
VLOOKUP Question.. | Excel Discussion (Misc queries) |