Look up with 2 factors
 

I have a table that shows multiple gravity factors for each degree of
temperature as an example.
38 38.5 39 39.5 (Gravity)
40 degrees 5 4 3 2
40.5 degrees 4 3 2 1
I need to lookup up the degrees and look up the gravity and the result be
the intersection of the proper degree with the gravity.

Any help would be appreciated.

Look up with 2 factors
 

=INDEX($A$1:$E$5,MATCH(40.5,$A$1:$A$5,0),MATCH(38. 5,$A$1:$E$1,0))
should retrieve the correct value from the below table. You can change the
values 40.5 and 38.5 to a cell reference

A1 38 38.5 39 39.5
40 5 4 3 2
40.5 9 8 7 6
50 6 5 4 3
50.5 8 1 6 1


If this post helps click Yes
---------------
Jacob Skaria


"AMC" wrote:

I have a table that shows multiple gravity factors for each degree of
temperature as an example.
38 38.5 39 39.5 (Gravity)
40 degrees 5 4 3 2
40.5 degrees 4 3 2 1
I need to lookup up the degrees and look up the gravity and the result be
the intersection of the proper degree with the gravity.

Any help would be appreciated.