| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup table between two ranges
Hi,
I would like to lookup a value (entered in cell D1) in the table below. For example if it were between 0 and 2 it would return R1, if it were between 3 and 5 it would return R2, etc. (starting in column A1) 0 2 R1 3 5 R2 6 8 R3 Any help would be gratefully received |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Name ranges and Lookup | Excel Worksheet Functions | |||
| Lookup Value between 2 ranges | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| vlookup using two table ranges | Excel Worksheet Functions | |||
| Ranges with in a LOOKUP | Excel Worksheet Functions | |||
Threaded Mode
