| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help. Trying to do the opposite of VLOOKUP
I have a specific number X in a cell and in the column beside I have a list of data that ranges from smalles to largest. I need to find a number in that column the is = or than X. the number should be the closest number to X but greater.
Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opposite direction | Excel Worksheet Functions | |||
| Opposite of Vlookup | Excel Discussion (Misc queries) | |||
| opposite of vlookup function? | Excel Discussion (Misc queries) | |||
| Now I want the opposite | Excel Programming | |||
| The opposite of IF function gives #VALUE for value = 0 | Excel Worksheet Functions | |||
Threaded Mode
