Use
=INDEX(Sheet2!$C$2:$C$29,MATCH(1,(A2=Sheet2!$A$2:$ A$29)*(B2=Sheet2!$B$2:$B$29),0))
This is an array formula.
You will have to confirm with Ctrl & Shift & Enter.
Paste this into C2 and then click in the formula bar and then Ctrl & Shift & Enter.
This puts {} around the formula.
You can then drag the formula down.