Here is the problem:
i have a data table with 2 columns:
Lets say i have a cell with number 3. I need to find a number in column A that has a number >= than 3, but also has the smallest number in column B.
(with my cell = 3 it would be 3.04 from A and 5.33 from B)
Simple vlookup gives me first >= number, but in most cases in column B is not the smalest number.
Array formula in E4:
Array formula in E5:
Functions in this article:
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range
Returns the smallest number in a set of values. Ignores logical values and text
MATCH(lookup_value;lookup_array; [match_type] Returns the relative position of an item in an array that matches a specified value