Sheet1!D2=INDEX(Sheet2!$C$2:$E$8,MATCH(Sheet1!B2,S heet2!$B$2:$B$8,0),MATCH(Sheet1!C2,Sheet2!$C$1:$E$ 1,0))

and drag down