matching data numbers

Hi

As attached sample, how can i find the data in column C(blue) matched with the data in Column A (yellow)?

And copy the column C data into column B.

Thanks

Hi okl,

You need an Index Match formula like:
=INDEX(C:C,MATCH(A2,C:C,0))
Index Match A to C.xlsx