Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Trying to create a lookup using thresholds. Col B represents the upper
limit, Col C represents the return value. Using the table below: If I had a cell in Col A with the value of 8, I would expect a return value of 1 from Col C. If I had a cell in Col A with the value of 78, I would expect a return value of 3 from Col C. Col B Col C 18 1 54 2 90 3 126 4 162 5 198 6 234 7 270 8 306 9 342 10 378 11 414 12 450 13 486 14 522 15 558 16 594 17 Is there a lookup formula for this? Is there a better way of doing this? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Thresholds | Charts and Charting in Excel | |||
Lookup formula - please help! | Excel Discussion (Misc queries) | |||
Create a Bullseye chart with value thresholds | Excel Discussion (Misc queries) | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
Negative Thresholds in SumProduct | Excel Discussion (Misc queries) |