Try Vlookup

=Vlookup(A2,'Sheet1'!$D$6:$H$18,2,FALSE)

adjust as necessary