In E2 try:

=VLOOKUP(A2,Sheet2!A:D,4,0)

copied down