Excel Interpolate Table

Now we need to interpolate on c to get 20+(35-20).2 = 23. If there is not table value for alpha =.03, but there are table values for alpha =.02 and.05, then you repeat the above process to get a value where r = 4.5, c = 3.2 and alpha =.02. You also repeat this process to get a value for r = 4.5, c = 3.2 and alpha =.05. Excel Linear Interpolation Linear interpolation in excel means forecasting or guessing the upcoming next value of any certain variable given on the current data, here we create a straight line which connects two values and we estimate the future value through it, in excel we use forecast function and a lookup function to do a linear interpolation.

Excel Interpolate Table Function
Excel Interpolate Table Definition
Excel Interpolation Equation
Excel Linear Interpolation From Table
Excel Linear Interpolate Table

Hi Guys,
I've recorded engine data and two of the variables recorded were engine speed and coolant temperature. To determine friction torque, the table below needs to be used:

Engine Speed	400	800	1000	1100	1200	1300	1400	1500	1600	1800	2000	2200	2400	2600	2800	3000
Coolant Temperature
-30.04	80	96	104.4	108.9	113	117.8	122.7	127.6	132.5	141	148	156	161.7	168	176	183
-20.04	65	82	90.2	93.9	98.1	102.6	107.5	112	117.3	125	132.3	139.2	144.9	150	156.2	162
-10.04	55	69	76	80.3	83.6	87.8	92	96.5	101	107.7	115	121	127.5	133.7	139.3	145
-0.04	48	59	63	66.8	69.5	72.9	76.8	80.6	85	92.5	99	106	113	119.1	125.7	133
9.96	45.5	54.3	58.7	60.8	62.7	66	69	72.9	77	85	92	100	106	112.5	119	125.5
19.96	43.8	52.3	56.5	58.5	60.4	63.6	65.9	69.1	72.2	80.1	87.1	95	102.1	108	115	120.9
29.96	42.2	50.3	54.4	56.3	58.1	61.2	63.5	66.5	69.5	77.1	83.9	91.5	98.3	104	110.5	116.4
39.96	40.5	48.4	52.3	54.1	55.9	58.8	61	63.9	66.7	74	80.6	87.9	94.4	100	106	111.8
49.96	39.3	43.8	46.6	48	49.3	51.5	53.2	55.5	57.6	63.1	68.2	73.9	80.5	86	92	100.3
59.96	38	39.2	40.8	41.8	42.7	44.1	45.4	47	48.5	52.1	55.8	59.8	66.5	73.2	80.9	88.7
69.96	38	39.2	40.8	41.8	42.7	44.1	45.4	47	48.5	52.1	55.8	59.8	66.5	73.2	80.9	88.7
79.96	38	39.2	40.8	41.8	42.7	44.1	45.4	47	48.5	52.1	55.8	59.8	66.5	73.2	80.9	88.7
89.96	38	39.2	40.8	41.8	42.7	44.1	45.4	47	48.5	52.1	55.8	59.8	66.5	73.2	80.9	88.7
99.96	38	39.2	40.8	41.8	42.7	44.1	45.4	47	48.5	52.1	55.8	59.8	66.5	73.2	80.9	88.7
109.96	38	39.2	40.8	41.8	42.7	44.1	45.4	47	48.5	52.1	55.8	59.8	66.5	73.2	80.9	88.7
119.96	38	39.2	40.8	41.8	42.7	44.1	45.4	47	48.5	52.1	55.8	59.8	66.5	73.2	80.9	88.7

<colgroup><col><col><col span='16'></colgroup><tbody>
</tbody>
The values in the main body of the table are friction torque. I would like to be able to calculate friction torque for a range of engine speeds and coolant temperatures. I think I have to interpolate the table to do this. How do I interpolate the table on Excel?
Below is a small sample of my spreadsheet. I would like a formula to calculate the friction torque by using the values in the engine speed and coolant temperature columns, and then using the table above. Any suggestions?

Coolant Temperature (°C)	Engine Speed (rpm)	Friction Torque (Nm)
30	940
30	940
30.16	940
30.16	937
30.2	937.5
30.5	938
30.6	941
30.6	941
31	941
31	940.5
31	939
31	938.5
31	939.5
31.9	940
32	941.5
32.5	942.5
32.5	939
32.5	939.5
32.6	941.5
33	942
33.4	942.5
33.5	943
35	942

Excel Interpolate Table Function

Excel Interpolate Table Definition

Excel Interpolation Equation

Thanks,

Excel Linear Interpolation From Table

Excel Linear Interpolate Table

David