| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need LOOKUP to find the number above not below the specified numbe
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need LOOKUP to find the number above not below the specified numbe
see your other post
-- Biff Microsoft Excel MVP "Ivan" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find previous number and find next number in column | Excel Discussion (Misc queries) | |||
| lookup or find matching number in text string | Excel Worksheet Functions | |||
| Find Column Number via Lookup | Excel Worksheet Functions | |||
| LOOKUP OR INDEX/MATCH TO FIND NUMBER? | Excel Discussion (Misc queries) | |||
| count a number that is less than a number and greater than a numbe | Excel Worksheet Functions | |||
Linear Mode
