Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to Look in a one-row or one-column range for a value and return a
value from the same position in a second one-row or one-column range, but instead of returning the largest value in lookup_vector that is less than or equal to lookup_value I want to return the largest value in lookup_vector that is greater than or equal to the lookup_value. Example, lookup_value is 53 Col1 Col2 Row1 16 50 Row2 25 63 I want a formula that can return 25 instead of 16(using lookup function) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup number greater than | Excel Worksheet Functions | |||
Vlookup match greater than lookup value | Excel Worksheet Functions | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
lookup finding the next value that is GREATER | Excel Worksheet Functions | |||
vlookup - finding the next value that is GREATER than the lookup value? | Excel Worksheet Functions |