Hi, sorry will try and explain again, Column A & B are the same legnth and are aligined correctly. What I want to do is each time a data item in B matches C I want the ref in A to be placed in Column D. The difficulty is, as the Ref in C repeats so many times normal Match is not working. Column B and A have 950 values. Column C has 29,000. So I want to end up with 29,000 refs from A matching the correct values in C. Example columns below..am struggling with the formating so will show each column one after the other.

Column A Values

REQ123
REQ124
REQ125
REQ126
REQ127
REQ128
REQ129
REQ130
REQ131
REQ132
REQ133
REQ134
REQ135
REQ136
REQ137


Column B Values

12234
12235
12236
12237
12238
12239
12240
12241
12242
12243
12244
12245
12246
12247
12248


Column C Values

12234
12234
12234
12234
12234
12234
12234
12234
12234
12235
12235
12235
12235
12235
12235
12235
12235
12235
12236
12236
12236
12236
12236
12236
12236


Column D Values

REQ123
REQ123
REQ123
REQ123
REQ123
REQ123
REQ123
REQ123
REQ123
REQ124
REQ124
REQ124
REQ124
REQ124
REQ124
REQ124
REQ124
REQ124
REQ125
REQ125
REQ125
REQ125
REQ125
REQ125
REQ125