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.
|