How to pull information from table with multiple variables?

[Insomnia81]

What I'm trying to do is have a formula return a correct value in the "H" column depending on "Item #" and "Location". The numbers 1-7 on the table at the bottom are the "Item #". So for example cell H2 should be "15" from cell D7.

I assume this has to be done with index and match, but I'm not too familiar with the formula. I tried a combo of v and h lookups, but I got a huge mess where I couldn't find the error.

 

[Vbagreenhorn1]

=index(b7:h8,match(d2,a7:a8,0),match(a2,b6:h6,0))

 

[palaeontology]

Try this in H2 and drag down .... =INDEX($A$5:$H$7,MATCH($D1,$A$5:$A$7),MATCH($A1,$A$5:$H$5))

Kind regards,

Chris