| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
lookup tables
If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the
largest value that is less than or equal to lookup_value. I want to find the next LARGEST value in a table that I have sorted. Is this possible? |
|
#2
|
|||
|
|||
|
Richard D wrote:
If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than or equal to lookup_value. I want to find the next LARGEST value in a table that I have sorted. Is this possible? Looks like... =INDEX(ReturnRange,MATCH(LookupValue,MatchRange,1) +(LOOKUP(LookupValue,MatchRange)<LookupValue)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
| lookup tables in cells | Excel Worksheet Functions | |||
| Lookup Function Problem | Excel Discussion (Misc queries) | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
