If we have a table of data values, can we build a graph and extract values
from it not found in the table?
Example pairs 2200, 1,21; 2400, 1.37 are in table from which a (non-linear)
graph is created. Is there any simple way to find the value that goes with
2217, for example?

I know we can use match and index and do linear interpolation, but is there
a simpler or more elegant way to do this?

FORECAST() both forecasts and interpolates:
In A1:B2 put:

2200 1.21
2400 1.37

anywhere else put =FORECAST(2217,B1:B2,A1:A2) and you will see: 1.22360

--
Gary's Student


"TauBrewer" wrote:

If we have a table of data values, can we build a graph and extract values
from it not found in the table?
Example pairs 2200, 1,21; 2400, 1.37 are in table from which a (non-linear)
graph is created. Is there any simple way to find the value that goes with
2217, for example?

I know we can use match and index and do linear interpolation, but is there
a simpler or more elegant way to do this?