| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
LOOKUP and higher value
I'm currently using the LOOKUP function to return a corresponding value,
however if the number being looked for falls between 2 numbers in the list, the lower of the two numbers is returned. Is it possible for the higher of the two to be returned? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index lookup and duplicate numbers | Excel Worksheet Functions | |||
| Matching unsorted lookup values | Excel Worksheet Functions | |||
| really need some help on this lookup | Excel Discussion (Misc queries) | |||
Threaded Mode
