In G2 copied down...
Code:
=INDEX(Sheet1!$G$3:$J$7,
MATCH($B2&$E2,Sheet1!$C$3:$C$7&Sheet1!$A$3:$A$7,0),
MATCH($A2,Sheet1!G$1:J$1,0))
IMPORTANT- This is an array formula
- Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
- If entered correctly, the formula will be enclosed in {brackets}
- Do not enter the {brackets} manually