Look up with 2 factors

  • Thread starter Thread starter AMC
  • Start date Start date
A

AMC

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.
 
=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
 
Back
Top