Lookup 2 values to return 1 value

See attached... I just converted column B in Sheet A by selecting the column and going to Data|Text to Columns and clicking Finish.

When you first enter the formula in G8, confirm it with CSE keys and then copy it across (and down).

Note: To get rid of those ugly #N/A formulas, use an error trap...

Replace formula in G8 with:

=IF(ISNUMBER(MATCH(1,IF(A!$A$2:$A$83=$B8,IF(A!$B$2:$B$83=G$6,1)),0)),INDEX(A!$H$2:$H$83,MATCH(1,IF(A!$A$2:$A$83=$B8,IF(A!$B$2:$B$83=G$6,1)),0)),"")

and then reconfirm it with CSE keys and then copy across and down.