Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Table
Is is possible to look up a value (Sales) in a table of ranges and return
another value depending on which range it falls into? Code Sales Min Sales Max A 10000 B 8000 10000 C 6000 8000 D 0 6000 So say I enter 9500 in a cell, I want it to return "B" as 9500 falls witin that range of 8000-12000. I've already created an IF statement that works but as I get more and more ranges, it's going to get confusing and I think it maxes out at 7 conditions. Just thought there might be an alternative to creat a table for the ranges and do some sort of lookup or something. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Value in Table | Excel Worksheet Functions | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Lookup table help please | Excel Discussion (Misc queries) | |||
Lookup Table help | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |