Linear Interpolation of a Table with two variables and different steps

[nickthebizz]

Hi,

I have a table which i need to interpolate a range within two variables.

On the top row is density which steps up 000.1 each time.

On the far left column is temperature which consists of different steps eg.

7
7.1
7.2
then
7.25
7.3
7.4 and so on

I need to find the value of a specific density(top row) at a specific temperature(far left column).

the temperature could be for example 7.23degrees.

Now I need to interpolate the values in yellow to find the specific value(VCF) on the yellow values for a specific temperature 7.23degrees.

Notice that the temperature changes steps of a range 0.00001 from 0.1 from 7 degrees until 7.2 but from 7.2 until 7.25 the step in the yellow table changes by 0.00002 and so own.

Could anyone have an idea how to make a small window in excel where i have add:

The density
The temperature

and the result will give me an interpolated value from the yellow table?

 

[MrTomasz]

use:
'Z1 is where you provide value from colum a
'Z2 is where you provide value from row 1
'A1:L14 is your table
'B1:L1 is your headers in row 1

=VLOOKUP(Z1;A1:L14;MATCH(Z2;B1:L1;0)+1;FALSE)

 

[nickthebizz]

thanks It is working just how i needed it.

Is there a possibility to make the vlookup search in two tables? from two different ranges?