Matching Multiple repeating values in one column with another

**stevebbbb** · 10-23-2009, 03:36 PM

Matching Multiple repeating values in one column with another.

I have a three columns of data that I need to map the requird Ids in Col A against multiple repeats in Col C. AS per data below

ID req Ids Repeating values
REQ123 12234 12234
REQ124 12235 12234
REQ125 12236 12234
REQ126 12237 12234
REQ127 12238 12234
REQ128 12239 12234
REQ129 12240 12234
REQ130 12241 12234
REQ131 12242 12234
REQ132 12243 12235
REQ133 12244 12235
REQ134 12245 12235
REQ135 12246 12235
REQ136 12247 12235
REQ137 12248 12235
REQ138 12249 12235
REQ139 12250 12235
REQ140 12251 12235
REQ141 12252 12236
REQ142 12253 12236
REQ143 12254 12236
REQ144 12255 12236
REQ145 12256 12236
REQ146 12257 12236
REQ147 12258 12236
....................12237
....................12237
....................12237
....................12237
....................12237
....................12237
....................12237
....................12237
....................12237

Any ideas how I can do this?

Thanks

steve

**rwgrietveld** · 10-23-2009, 04:09 PM

Column A and C do not match. Please specify the before and after situation by example.

**stevebbbb** · 10-24-2009, 05:32 AM

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

**JBeaucaire** · 10-24-2009, 01:03 PM

In D1:

=INDEX(A:A, MATCH(C1, B:B, 0))
...and copy down.

**stevebbbb** · 10-24-2009, 02:27 PM

Thanks loads - JBeaucaire, that works a dream!

Cheers.

Steve

PS - do I need to set this to resolved?

**JBeaucaire** · 10-24-2009, 06:58 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)