Find value where x & y of a table meet.

[DeepRockEnergy]

Hi, me and a co-worker have been trying to figure this out for quite some time now. I have a table w/multiple values in it. A2 through A6 have temperature values in it. B1 through F1 have gravity amounts in it. Below my table in a cell A10 i want to input a value for a specific temperature and cell A11 another value for specific gravity that i get from tickets. I want it to look through column A and Row 1 for my manually entered numbers and return the value where those numbers cross at. IE: Attached is a picture.

THANKS!!! JMM

 

[VoG]

Try like this http://j-walk.com/ss/excel/usertips/tip020.htm

 

[njimack]

Welcome to the board. Try this:
=INDEX(B2:F6,MATCH(A10,A2,A6,0),MATCH(A11,B1:F1,0))

 

[Lewiy]

Try this:

=INDEX($A$1:$F$6,MATCH(A10,$A$1:$A$6,0),MATCH($A$11,$A$1:$F$1))

 

[DeepRockEnergy]

Thank you all so much!!! Much appreciated!