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:


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?

Attached Files

msofficeforums50827_R.xlsx (12.7 KB, 3 views)