Compare A to B(C) and insert C for A

[february24]

Hello guys,

I have a table with 4 columns:

A is a list of numbers 12345, 23456, 34567 etc all unique, ascending sort
B is a list of types, its either 1 or 11 or 3
C is a list of the same numbers as A but they are not sorted and that cant be changed
D is where I need to insert the type (1, 11, 3) for each number in C

Ideally, it will take A2, find it in column Cxxx, and insert the type from B2 to Dxxx and continue doing it for each row

Any ideas on how to do this?

Thanks!