| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup finds the next higher number in a range
Suggestion to have lookup find the next nearest high number in a range. Use
should be able to select whether lookup finds the next higher or next lower number if an exact match is not found. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP the number higher not lower | Excel Discussion (Misc queries) | |||
| lookup only finds #n/a's | Excel Discussion (Misc queries) | |||
| LOOKUP and higher value | Excel Discussion (Misc queries) | |||
| Excel finds a value that is not in the lookup range | Excel Worksheet Functions | |||
| Need a function that finds a value in a table range and returns the cell number | Excel Programming | |||
Threaded Mode
