| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup less than a number
Hello.
I would like to be able to do the equvivalent of: look up a number in range MaxTermAvail and if the number is < the left value then bring back the next col; something like Vlookup (B2, if B7<the left value(MaxTermAvail), 2, false). So, if B2=61 then the value returned should be 15, when MaxTermAvail= 41 35 46 30 61 20 66 15 71 10 Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number lookup | Excel Worksheet Functions | |||
| lookup returns row number-why? | Excel Worksheet Functions | |||
| lookup based on a row number | Excel Worksheet Functions | |||
| Part Number Lookup | Excel Worksheet Functions | |||
| Number Lookup in Matrix | Excel Worksheet Functions | |||
Threaded Mode
