Help! Is there a way to Interpolate (x, y, Known value X)?

Is there a way to Interpolate (x, y, with known X value) between 2 tables?

TABLE 1 TABLE 2
X! Y1 X Value Result
100 2,500 150 3050
200 3,600
300 4,200

Any help would be appreciated.

0 11 1,855
11 REPLIES 11
Top Labels in this Space