Finding cell by criteria

[Shaknhands]

I've got two large worksheets that I use on a daily basis that I have been scrolling through for years manually locating the values in a cell by the criteria according the the row/column headers. Both worksheets are 151 Rows x 101 columns.

The value I find in the first worksheet is then used to find another in the second worksheet. Is there a formula that can be used to get this to automatically located the cell by referencing the row/column headers as the criteria?

Also the first cell value that is located will probably need to be rounded to the nearest 0.5!

Would it be easier for someone relatively new to excel to just stick with locating this information manually?

[Shaknhands]

I've attached a small example.

[davesexcel]

I've attached a small example.

Try placing this formula in G6
Your degrees headings are not numbers but text so you will have to change them to numbers for a formula to work....
=INDEX($C$11:$I$17,MATCH(C6,$C$10:$I$10,0),MATCH(E6,$B$11:$B$17,0))

Here's more on index match
http://www.contextures.com/xlFunctions03.html

[Shaknhands]

I finally got it to work once I switched the two criterias around!

Thank you so much!