The attached has a result in cell L5 which does NOT give you the closest R but a value of R interpolated (linear regression) from the 2 closest values in the appropriate column to the given R.
The formula in L5 is:
Code:
=ReverseY(B4:G18,J3,J4)
Note that B4:G18 is the table EXCLUDING the very top row with the label V.
You get hints about what belongs where in the formula:
2023-05-06_184759.jpg
The formula is a
lambda formula given the name
ReverseY in the
Name Manager.
There's a cell O5 showing that lambda formula, but it's there only for information, it's not needed.
ps. if you had the value of 583 for a V of 40, that's exactly midway between 580 and 586, what would the 'closest' Y be?