Hi,

I have two sets of data, one in A1:A450 and the other in D1:D700. I want
the matching data (reference) of the array in column A to appear in Column C
or next to the matched value of column D.

Example:

A B C D
23 14
12 52
37 89
45 23 23

Thanks in advance for your help.