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

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!

=LOOKUP(C2,A:B) should do it if you have unique sorted list in column A..

or =SUMIF(A:A,C2,B:B)

The first LOOKUP() formula should pull up the last occurance of the lookup value... which I presume is the same for all duplicates....so shouldn't matter.. or does it somehow?

If you didn't want to format as numbers... then

=Vlookup(C2,A:B,2,0)