| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Vlookup help ... or something similar
VLOOKUP and the like return the next lowest value when the exact
search value cannot be found. I need to be able to return the next highest value. For example, I want to return 112000 when I search the following table for the value 760 (in cell A2, say): B C 75 20000 150 37000 300 60000 450 76000 600 87000 750 94000 1250 112000 =vlookup(a2,b1:c7,2) finds 750 and returns 94000 ... I need it to find 1250 and return 112000. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using VLOOKUP to match similar text? | Excel Worksheet Functions | |||
| Similar to Vlookup | Excel Discussion (Misc queries) | |||
| Vlookup on a worksheet with similar values | Excel Worksheet Functions | |||
| FIND FORMULA SIMILAR TO VLOOKUP FOR NON-ASCENDING VALUES | Excel Worksheet Functions | |||
| Vlookup on multiple similar entries / NO VBA | Excel Worksheet Functions | |||
Threaded Mode
