I am trying to to match and order column B with column A. If you notice the cells in B share the same code but also alot of other stuff. I'm wanting them to be matched and in the same order as column A is, so there will obviously be blank spaces in between. So for example B1 would be matched with A79.
matcher test.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | TSTPK1 | https://acquiredcapitalmn.com/78767876/IPA Pictures/4105.jpeg | ||
2 | 7865L | https://acquiredcapitalmn.com/78767876/IPA Pictures/5705A-RT.jpeg | ||
3 | 7893 | https://acquiredcapitalmn.com/78767876/IPA Pictures/5710A-RT8.jpeg | ||
4 | 7897 | https://acquiredcapitalmn.com/78767876/IPA Pictures/5710A-T10.jpeg | ||
5 | 8000 | https://acquiredcapitalmn.com/78767876/IPA Pictures/7862-6PK.jpeg | ||
6 | 8010 | https://acquiredcapitalmn.com/78767876/IPA Pictures/7862H.jpeg | ||
7 | 8026 | https://acquiredcapitalmn.com/78767876/IPA Pictures/7863.jpeg | ||
8 | 8027 | https://acquiredcapitalmn.com/78767876/IPA Pictures/7864.jpeg | ||
9 | 8028 | https://acquiredcapitalmn.com/78767876/IPA Pictures/7865L(2).jpeg | ||
10 | 8029 | https://acquiredcapitalmn.com/78767876/IPA Pictures/7865L.jpeg | ||
11 | 9101 | https://acquiredcapitalmn.com/78767876/IPA Pictures/7880.jpeg | ||
12 | 9102 | https://acquiredcapitalmn.com/78767876/IPA Pictures/7881.jpeg | ||
13 | 9107A | https://acquiredcapitalmn.com/78767876/IPA Pictures/7882.jpeg | ||
14 | 9120 | https://acquiredcapitalmn.com/78767876/IPA Pictures/7884.png | ||
15 | 8001D | https://acquiredcapitalmn.com/78767876/IPA Pictures/7885.jpeg | ||
16 | 8002 | https://acquiredcapitalmn.com/78767876/IPA Pictures/7893.jpeg | ||
17 | 8004 | https://acquiredcapitalmn.com/78767876/IPA Pictures/7894.jpeg | ||
18 | 8004D | https://acquiredcapitalmn.com/78767876/IPA Pictures/7897.jpeg | ||
19 | 8037 | https://acquiredcapitalmn.com/78767876/IPA Pictures/7902.jpeg | ||
20 | 8038 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8000.jpeg | ||
21 | 8080 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8001D.jpeg | ||
22 | 8080D | https://acquiredcapitalmn.com/78767876/IPA Pictures/8002.jpeg | ||
23 | 8081 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8004.jpeg | ||
24 | 8083 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8004D.jpeg | ||
25 | 8084 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8005.jpeg | ||
26 | 8085 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8010.jpeg | ||
27 | 8087 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8016.jpeg | ||
28 | 8088 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8024.jpeg | ||
29 | 8090S | https://acquiredcapitalmn.com/78767876/IPA Pictures/8025.jpeg | ||
30 | 8090B | https://acquiredcapitalmn.com/78767876/IPA Pictures/8026.jpeg | ||
31 | 8095 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8027.jpeg | ||
32 | 8108 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8028.jpeg | ||
33 | 8120 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8029.jpeg | ||
34 | 8150 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8030.jpeg | ||
35 | 8151 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8031.jpeg | ||
36 | 8024 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8035A.jpeg | ||
37 | 8025 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8037.jpeg | ||
38 | 8030 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8038.jpeg | ||
39 | 8031 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8040.jpeg | ||
40 | 8035A | https://acquiredcapitalmn.com/78767876/IPA Pictures/8041.jpeg | ||
41 | 8040 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8042.jpeg | ||
42 | 8041 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8043.jpeg | ||
43 | 8042 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8044.jpeg | ||
44 | 8043 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8045.jpeg | ||
45 | 8044 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8047.jpeg | ||
46 | 8045 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8048.jpeg | ||
47 | 8047 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8050.jpeg | ||
48 | 8048 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8051.jpeg | ||
49 | 9010 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8052.jpeg | ||
50 | 7880 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8053.jpeg | ||
51 | 7881 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8055.png | ||
52 | 7882 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8056.png | ||
53 | 7884 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8057.png | ||
54 | 7885 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8058.png | ||
55 | 7894 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8080.jpeg | ||
56 | 8005 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8080D.jpeg | ||
57 | 8016 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8081.jpeg | ||
58 | 9036 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8083.jpeg | ||
59 | 9037 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8084.jpeg | ||
60 | 9038 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8085.jpeg | ||
61 | 9038A | https://acquiredcapitalmn.com/78767876/IPA Pictures/8087.jpeg | ||
62 | 8055 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8088.jpeg | ||
63 | 8056 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8090B.jpeg | ||
64 | 8057 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8090S.jpeg | ||
65 | 8058 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8091.jpeg | ||
66 | 8091 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8095.jpeg | ||
67 | 7862 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8100.jpeg | ||
68 | 7862-6PK | https://acquiredcapitalmn.com/78767876/IPA Pictures/8108.jpeg | ||
69 | 7862H | https://acquiredcapitalmn.com/78767876/IPA Pictures/8120.jpeg | ||
70 | 7863 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8150.jpeg | ||
71 | 7864 | https://acquiredcapitalmn.com/78767876/IPA Pictures/8151.jpeg | ||
72 | 7902 | https://acquiredcapitalmn.com/78767876/IPA Pictures/9004M.jpeg | ||
73 | 8050 | https://acquiredcapitalmn.com/78767876/IPA Pictures/9005A.jpeg | ||
74 | 8051 | https://acquiredcapitalmn.com/78767876/IPA Pictures/9007A.jpeg | ||
75 | 8052 | https://acquiredcapitalmn.com/78767876/IPA Pictures/9007M.jpeg | ||
76 | 8053 | https://acquiredcapitalmn.com/78767876/IPA Pictures/9008-DL.png | ||
77 | 8100 | https://acquiredcapitalmn.com/78767876/IPA Pictures/9008-SE.jpeg | ||
78 | 9004M | https://acquiredcapitalmn.com/78767876/IPA Pictures/9010.jpeg | ||
79 | 4105 | https://acquiredcapitalmn.com/78767876/IPA Pictures/9036.jpeg | ||
80 | 9005A | https://acquiredcapitalmn.com/78767876/IPA Pictures/9037.jpeg | ||
81 | 9005A-EXT | https://acquiredcapitalmn.com/78767876/IPA Pictures/9038.jpeg | ||
82 | 9007A | https://acquiredcapitalmn.com/78767876/IPA Pictures/9038A.jpeg | ||
83 | 9007M | https://acquiredcapitalmn.com/78767876/IPA Pictures/9046F.jpeg | ||
84 | 9008-SE | https://acquiredcapitalmn.com/78767876/IPA Pictures/9046FH.jpeg | ||
85 | 9008-DL | https://acquiredcapitalmn.com/78767876/IPA Pictures/9046H.jpeg | ||
86 | 9008-DLEXT | https://acquiredcapitalmn.com/78767876/IPA Pictures/9049M.jpeg | ||
87 | 5610A-00 | https://acquiredcapitalmn.com/78767876/IPA Pictures/9101.jpeg | ||
88 | 5611A-00 | https://acquiredcapitalmn.com/78767876/IPA Pictures/9102.jpeg | ||
89 | 5610A-RT8 | https://acquiredcapitalmn.com/78767876/IPA Pictures/9107A.jpeg | ||
90 | 5611A-RT8 | https://acquiredcapitalmn.com/78767876/IPA Pictures/9200.jpeg | ||
91 | 5710A-T10 | https://acquiredcapitalmn.com/78767876/IPA Pictures/M2000.jpeg | ||
92 | 5710A-RT8 | https://acquiredcapitalmn.com/78767876/IPA Pictures/TSTPK1(2).jpeg | ||
93 | 5705A | https://acquiredcapitalmn.com/78767876/IPA Pictures/TSTPK1.jpeg | ||
94 | 5705A-NT | |||
95 | 5705A-RT | |||
96 | M5700 | |||
97 | M5700A | |||
98 | M5700A-RT | |||
99 | M2000 | |||
100 | 9200 | |||
101 | 9046F | |||
102 | 9046H | |||
103 | 9046FH | |||
104 | 9049M | |||
105 | 9068A | |||
106 | FIL-02PB6 | |||
107 | FIL-02WB6 | |||
108 | FIL-10WB6 | |||
109 | FIL-17WB6 | |||
110 | FIL-20PB6 | |||
111 | FIL-30PT6 | |||
112 | FIL00013 | |||
113 | FIL00001 | |||
114 | FIL00006 | |||
115 | FIL00005 | |||
116 | 9040-HB | |||
117 | PMP00001 | |||
118 | PMP00003 | |||
119 | PMP00004 | |||
120 | FX-0001 | |||
121 | DTP-INTAKE-AS | |||
122 | HS-RB12 | |||
123 | 9046-INHOSE-AS | |||
124 | 9046-OUTHOSE-AS | |||
125 | 9049-INHOSE-AS | |||
126 | 9049-OUTHOSE-AS | |||
127 | 9040-12EXT | |||
128 | 9040-24EXT | |||
129 | 9046-OUTPUT2-AS | |||
130 | 9046-OUTPUT-AS | |||
131 | 9046-INPUT-AS | |||
132 | 9046-BRWAND-AS | |||
133 | 9046-VALVE-AS | |||
134 | 9046-90DEG-AS | |||
135 | 9046-HSADPTR-AS | |||
136 | 9046-3 | |||
137 | HDL0004-AS2 | |||
138 | 9070-DEFMET | |||
139 | 9070-DEFNOZ | |||
140 | 9070A-NOZ | |||
141 | TEQ-5HLTC | |||
142 | 9060M5 | |||
143 | 9060M5A | |||
144 | 9060M4 | |||
145 | 9060M4A | |||
146 | 9060-1M | |||
147 | 9060-2M | |||
148 | 9068A-MOD | |||
149 | 9068-GLPT | |||
150 | 9060-BLUHOSE-AS | |||
151 | 9060-REDHOSE-AS | |||
152 | 9060-GRYHOSE-AS | |||
153 | 9060-YLWHOSE-AS | |||
154 | 9060-BLKHOSE-AS | |||
155 | MUTT2-BLES | |||
156 | MUTT2-T10 | |||
157 | MUTT2-RT8 | |||
158 | ST-BASE | |||
159 | 5700-TAB | |||
160 | 5700-TABRT | |||
161 | CBL-9INUSBMIC | |||
162 | 5700-RAMMNT-AS | |||
163 | 5700-MNTRT-AS | |||
164 | 5700-TABC | |||
165 | 5700-TABCH | |||
166 | MUT-RM12-4A | |||
167 | MUT-RM12-4105 | |||
168 | MUT-RM12 | |||
169 | MUT2-RM12 | |||
170 | 5700-BT-AS | |||
171 | CBL-OBD2MF-12 | |||
172 | CBL-OBD2EXT | |||
173 | 7900AP-8RD-AS | |||
174 | 7900AP-8BL-AS | |||
175 | 7900AP-11AS12 | |||
176 | 7900AP-12AS12 | |||
177 | 7900AP-11AS25 | |||
178 | 7900AP-12AS25 | |||
179 | 7900AP-12RED-FX | |||
180 | 7900AP-12BLU-FX | |||
181 | 5705-HS50 | |||
182 | 7900AP-17 | |||
183 | 7900AP-2640 | |||
184 | MUT-AIROUT-AS | |||
185 | MUT-REG-AS | |||
186 | MUT-REG-ASOLD | |||
187 | MUT-PRES-AS | |||
188 | 7900K-17A | |||
189 | 7900A-5A | |||
190 | 7900A-5B | |||
191 | 7900K-1 | |||
192 | 7900K-1-12 | |||
193 | 7900K-1-12A | |||
194 | 7900K-1-25 | |||
195 | 7900K-1-25A | |||
196 | 7900K-1-50-AS | |||
197 | 7900K-2BCHAS | |||
198 | BAT00002 | |||
199 | CHG-10AMP-AS | |||
200 | CHG-10AMP2-AS | |||
201 | CHG-121001 | |||
202 | CHR0001 | |||
203 | 7900K-80ACORD | |||
204 | 5600-PWRCBL-AS | |||
205 | 7900K-93 | |||
206 | 9005A-4AS | |||
207 | 9005A-5AS | |||
208 | 5700-BATJMPR-AS | |||
209 | 5700-6R | |||
210 | MUT-INTPWR-AS | |||
211 | MUT-INTPWR2-AS | |||
212 | 7900K-33 | |||
213 | MUT-EXTPWR-AS | |||
214 | 7900K-8Z | |||
215 | 7900K-WHLKIT | |||
216 | 7900K-48A | |||
217 | 5700-2 | |||
218 | 5700-12 | |||
219 | MUT-AXLE-RAW | |||
220 | 5700-AXLE-AS | |||
221 | 7900K-67F | |||
222 | 7900K-49 | |||
223 | HDL0011-AS2 | |||
224 | 9060-8P | |||
225 | 9008-8 | |||
226 | 5700-4 | |||
227 | CVR-0001 | |||
228 | CVR-0002 | |||
229 | KMUT-CAS-9004A | |||
230 | KMUT-CAS-9005A | |||
231 | KMUT-CAS-9007A | |||
232 | MUT-SOLX-AS | |||
233 | SW0002 | |||
234 | 7900K-2KIT | |||
235 | 7900K-18 | |||
236 | 7900K-11 | |||
237 | RSW0005 | |||
238 | RSW0006 | |||
239 | TBV00004AS | |||
240 | TBV00005AS | |||
241 | SOC0001B | |||
242 | 9008-4R | |||
243 | 9008-UPKIT | |||
244 | 7865-K | |||
245 | 8010-AS | |||
246 | CBL-8010-AS | |||
247 | ENC-0007 | |||
248 | PCB13A | |||
249 | RSW0002-L | |||
250 | K9102-HARNS-AS | |||
251 | K9101-HARNS-AS | |||
252 | RSW-0004 (6 pos) | |||
253 | RSW-0001 (7 pos) | |||
254 | KNOB0003 | |||
255 | FLASH01 | |||
256 | ENC-0001-1AS | |||
257 | ENC-0001-2AS | |||
258 | 9101LID | |||
259 | 9107A-AS | |||
260 | KCBL-9107-AS | |||
261 | 9107-3 | |||
262 | 8005-5AMP | |||
263 | 8005-10AMP | |||
264 | 8005-15AMP | |||
265 | 8005-20AMP | |||
266 | 8005-30AMP | |||
267 | 8005-7 | |||
268 | 8005-EXT | |||
269 | 8006-AS | |||
270 | 8012-AS | |||
271 | 8011 | |||
272 | 8014 | |||
273 | 8015 | |||
274 | 009036-1 | |||
275 | 009036-2 | |||
276 | 009036-3 | |||
277 | 009037-1 | |||
278 | 009037-2 | |||
279 | 009037-3 | |||
280 | 9036A-1 | |||
281 | 9036A-2 | |||
282 | 9036A-3 | |||
283 | 9037A-1 | |||
284 | 9037A-2 | |||
285 | 9037A-3 | |||
286 | 8090-8 | |||
287 | 8004-6AS | |||
288 | 8004-12AS | |||
289 | 8004-18AS | |||
290 | FIL-0820FL | |||
291 | FIL-0807SQ | |||
292 | FIL-0806R | |||
293 | FIL-0820HR | |||
294 | POU05 | |||
295 | 8160 | |||
296 | 8021 | |||
297 | 8022 | |||
298 | 8023 | |||
299 | 8040-S | |||
300 | 8040-M | |||
301 | 8040-L | |||
302 | FIL-030-3PK | |||
303 | FIL-040-3PK | |||
304 | FIL-050-3PK | |||
305 | FIL-060-3PK | |||
306 | FIL-070-3PK | |||
307 | FIL-080-3PK | |||
308 | FIL-090-3PK | |||
309 | FIL-100-3PK | |||
310 | FIL-110-3PK | |||
311 | FIL-120-3PK | |||
312 | CLR-040MPC | |||
313 | CLR-060MPC | |||
314 | CLR-090MPC | |||
315 | CLR90-BLK-AS | |||
316 | CLR160-BLK-AS | |||
317 | CLR250-BLK-AS | |||
318 | FIL-6FL | |||
319 | FIL-9FL | |||
320 | FIL-15FL | |||
321 | POU01 | |||
322 | POU01A | |||
323 | POU02 | |||
324 | POU03 | |||
325 | HDL0009-AS | |||
326 | BRB-0009 | |||
327 | 8091-VNT-AS | |||
328 | 8091-8 | |||
329 | HS-FUELYLW6 | |||
330 | 8091-1S-AS | |||
331 | 8091-1N-AS | |||
332 | 8091-11 | |||
333 | 7884-7 | |||
334 | 7902 | |||
Sheet1 |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
A32:A35 | Text length | <=15 |
A24:A28 | Text length | <=15 |