1) On sheet1, put this formula in D1, then copy down... you will get errors on the non-matches....



=INDEX(Sheet2!$C$1:$C$200, MATCH($B1&"-"&$C1, INDEX(Sheet2!$A$1:$A$200&"-"&Sheet2!$B$1:$B$200, 0), 0))

2) Copy that column

3) Do an Edit > Paste Special > Values to remove the formulas

4) With the data still highlighted, press F5 and click on Special

5) Select Constants > Errors > OK

6) Press DELETE and the error cells will be gone.