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 smallest number.
The formula extracts the smallest number larger than a given number displayed in cell F2.
Formula in E6:
Formula in cell F6:
MINIFS function was introduced in Excel 2016, you can use the following formulas if you don't have access to the function.
Array formula in E6:
Array formula in F6:
Explaining formula in cell E6
Step 1 - Construct logical expression
The logical expression is used in the IF function in order to return a given value. The > is a larger than sign.