One way...

With your data starting on row 2.

Enter this formula in A2 and copy down as needed:

=INDEX(C:C,MATCH(B2,D:D,0))