Hope the table below is still correctly formatted. You should see the top
row with 4 distinct "exact" year values (25, 30, 35, 40) and the left most
column with "approximate" percentage values. I need a formula that will
lookup this table to return the following result:
30 years at 83.5% will use 1.95% as the value in a formula.
25 30 35 40
100% 3.10% 3.30% 3.50% 3.70%
95% 2.75% 2.95% 3.15% 3.35%
90% 2.00% 2.20% 2.40% 2.60%
85% 1.75% 1.95% 2.15% 2.35%
80% 1.00% 1.20% 1.40% 1.60%
75% 0.00% 0.00% 0.00% 0.00%

Hope to hear from someone soon
Tks Loads
--
Elbowes