View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
txm49 txm49 is offline
external usenet poster
 
Posts: 17
Default LOOKUP FORMULA - USING THRESHOLDS - HELP

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!