I have a table of values that I want to lookup on but need the returned values to be interpolated if they're not exact matches, e.g.
Age Comp
0 0.01
3 0.02
6 0.03
9 0.04
12 0.05
24 0.10
36 0.13
48 0.12
60 0.10
90 0.09
So, if a person were, say, 65 years old, Excel will return a VLOOKUP value of 0.10. I want it to perform a simple linear interpolation between 0.10 and 0.09 based on the difference between 60 and 90 in the Age column.
Props and thanks in advance!
Age Comp
0 0.01
3 0.02
6 0.03
9 0.04
12 0.05
24 0.10
36 0.13
48 0.12
60 0.10
90 0.09
So, if a person were, say, 65 years old, Excel will return a VLOOKUP value of 0.10. I want it to perform a simple linear interpolation between 0.10 and 0.09 based on the difference between 60 and 90 in the Age column.
Props and thanks in advance!