Hi,

I'm working on a calculator for mortgage payments. On my calculator I
created a column with interest rate 1.000% - 11.000% and next to it I have a
column that automaticaly updates a ratio percentage I use for my calculator.

Column K Column O
1.000% 28.02%
1.010% 28.05%
1.020% -
-
-
-
11.000%

I have entered several formulas to get my values on Column O. When ever an
interest rate on column K equals to 31.00% on column O I have it highlight in
green. Since this column in long (Interest rate all the way down to H1004) I
want to enter a formula in cell B44 that will automatically update the exact
interest rate on column K that equals to 31.00% in column O instead of having
to scroll down the spreadsheet to find the Interest rate that equals to 31%.
Is this possible?

Thanks