Merge multiple tables in one table

Hi,
I have several tables, each table is for a specific altitude, where torque is calculated based on a given temperature.
I need help to find a way to create 1 table that uses all the calculation from the other tables, where torque is calculated based on given temperature and altitude.
For example:
for altitude 4000 and temperature 30, torque is 93.2.
for altitude 6000 and temperature 25, torque is 90.5.
What If I want the torque for altitude 5000 and temperature 20, is there any way?

I provided a sample for better understanding.

AttachmentSize
performance.xlsx9.67 KB

thanks

thanks

Double interpolation

You need a double interpollation on temperature and altitude.

Given you don't have many data points, you need assumptions. Please try this link as an example: https://www.box.com/s/1kfy1mqq1vfxymj9z3ba

Line 36, column 17 & 18 enter the temperature and altitude: the torque is calculated.

Hello, yes why not, please

Hello, yes why not, please give me the code.

Interpolation.

Yes, there is a way! you can do an interpolation . If you want the code to do an interpolation, just let me know.

If you rather prefer something more accurate... I have no idea.

I hope it helps