Try this...

Sheet2
A
B
C
D
1
------
------
------
------
2
Gim
Sum
Plim
1
3
Trook
Kluo
Seap
2
4
Mash
Pot
Soup
3
5
Reek
Gro
Lisp
4



Sheet1
A
B
C
D
1
------
------
------
------
2
Trook
Kluo
Seap
2
3
Gim
Sum
Plim
1
4
Reek
Gro
Lisp
4
5
Mash
Pot
Soup
3


This array formula** entered in D2 and copied down:

=INDEX(Sheet2!D$2:D$5,MATCH(1,(Sheet2!A$2:A$5=A2)*(Sheet2!B$2:B$5=B2)*(Sheet2!C$2:C$5=C2),0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.