In sheet1 c2 and drag it down
=IFERROR(INDEX(Sheet2!$C:$C,MATCH(A2&B2,INDEX(Sheet2!$A:$A&Sheet2!$B:$B,0),0)),0)