| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP the number higher not lower
I have a problem I'm trying to put together a spreadsheet and need the lookup
command, the lookup command is designed to look at the numbers in the table and find the one that is the same or the next one down from what you are looking for. What I need is to get it to look up the same number or the next number up from the one Im looking for. Can someone help me on how to get that done. Thanks In Advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select range higher than and lower than | Excel Discussion (Misc queries) | |||
| LOOKUP and higher value | Excel Discussion (Misc queries) | |||
| Can I flag numbers that are higher/lower than a range of #'s | Excel Worksheet Functions | |||
| need to select closest match using vlookup if it higher or lower | Excel Discussion (Misc queries) | |||
| How can I find the row nr of the first number lower/ higher then a | Excel Discussion (Misc queries) | |||
Threaded Mode
