| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup a value in a table
I need to lookup a value in a table, using the first 2 columns as a range,
then return the approp value from the 3rd column. For example lookup 8, as it falls between 7 and 9, I want to return e. 18 would give me m as would 25. col1 col2 col3 1 6 q 7 9 e 11 25 m |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| table lookup | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| Help with lookup table | Excel Worksheet Functions | |||
| lookup or table, not sure what to do | Excel Worksheet Functions | |||
| Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
