Spreadsheet: 752979d1635171783-lookup-single-value-in-multiple-columns-return-match-example-5-indexandsmall
Sheet: Data

Run # | RunID | RunID | RunID | RunID
100 | SMCH-09
101 | PETF-07
102 | SMCH-01
103 | CCSS-04
104 | SMCH-10
105 | SJOH-17
106 | SANS-05
107 | SCOR-62S
200 | BANT-72S | RYER-60S
201 | LAUR-80S | SBER-80S
202 | DAVI-65S | WJUR-61S
203 | LAUR-61S | FDRO-62S
204 | RMCS-82S | WCEN-60S
205 | LAUR-72S | FAIR-62S
206 | SOUT-62S | EAGL-60S
207 | WMSS-65S | FDRO-63S
208 | RMCS-64 | WORT-60S
209 | MONT-73S | EVHA-61S | EVHA-90S AM
210 | MONT-63S | MOUN-62S
211 | LDSS-61S | EVHA-60S
212 | CARA-61S
213 | LCSS-68S | CLEA-60S
214 | LCSS-63S | ECAR-61S
215 | MONT-65S | WORT-61S
216 | MONT-66S | EVHA-80S
217 | SOUT-64S | ECAR-60S
218 | MONT-77S | CHIP-62S
219 | LAUR-63S | LNEL-61S
220 | JPII-62S | PCHA-61S
221 | JPII-80S | CHIP-63S
222 | LCSS-61S | SIBR-63S
223 | BEAL-63S | RIVS-60S
224 | SOUT-61S | LNEL-60S
225 | LCSS-65S | WORT-62S
227 | LAUR-73S | SIBR-60S
228 | MONT-74S | MOUN-65S
229 | MONT-72S | MOUN-67S
230 | CARA-62S
231 | NMEA-61S
232 | NMEA-62S
233 | DAVI-69S | WILB-60S
234 | MONT-87S | SDAV-60S
235 | MEDW-80S | CNTL-60S
236 | MONT-86S | SCRE-63S
237 | ROBA-64S
238 | ROBA-65S
239 | ROBA-66S
240 | ROBA-67S
241 | ROBA-61S
242 | ROBA-73S
247 | LAUR-71S | LELG-60S
250 | LAFI-60S | CHOL-60S | BANT-85S PM
251 | SAUN-64S | ACAR-60S
252 | PAFI-62S | FDRO-60S
253 | BANT-63S | SCRE-62S
254 | PAFI-61S | SPIX-60S
255 | BANT-65S | KNOL-61S
256 | MEDW-65S | HILL-60S
257 | MONT-61S | FDRO-61S
258 | RMCS-63S
259 | JPII-61S | FAIR-61S
260 | BANT-60S | FAIR-63S
261 | PAFI-60S | HFAL-60S
262 | MTSS-61S | SGRG-61S
263 | RMCS-61S | NWIL-60S
264 | JPII-60S | PCHA-60S | CRSS-93S
265 | BEAL-60S | BONM-60S
266 | MONT-70S | CCAR-60
267 | LCSS-62S | SCRE-61
268 | [NAME] | CHIP-61S
269 | MEDW-60S | SPAL-60S
270 | JPII-10S | WNIS-60S
271 | RMCS-60S | SFLD-60S
272 | MEDW-61S | OXBO-60S
273 | ROBA-63S
275 | BANT-70S | STCA-60S
276 | BEAL-61S | CART-60S
277 | OAKR-62S | SBRO-60S
350 | [NAME] | FDRO-03
351 | LCSS-01 | ECAR-01
352 | BEAL-02 | SFRA-04
353 | CCSS-02 | SMTN-03
354 | CCSS-14 | PELI-03
355 | CCSS-10 | SMTN-02
356 | LUCA-01 | CNTL-04
357 | LUCA-04 | NRDG-02
358 | CCSS-07 | BSAC-01
359 | CCSS-18 | BSAC-02
360 | MTSS-07 | SMIL-03
361 | LAFI-07 | SCRE-02
362 | MONT-01 | [NAME]
363 | LAFI-08 | JACK-01
364 | BEAL-10 | SANL-01
365 | MTSS-01 | SMRK-01
366 | LUCA-02 | SMRK-05
367 | LAFI-09 | MASO-05
368 | LUCA-06 | NRDG-01
369 | BEAL-11 | PCHA-01
370 | BEAL-03 | ECAR-02
371 | LAFI-15 | SANL-02
372 | LAFI-12 | MASO-06
373 | BEAL-01 | PCHA-02
374 | LAFI-06 | CHOL-01
400 | MTSS-20
401 | FPAR-62S
402 | CRSS-70S | MOUN-66S
404 | CRSS-81S | ASHO-80S
405 | CRSS-82S | SANL-60S | CRSS-71S PM
406 | CRSS-85S | SBER-60S
407 | CRSS-83S/95S | CLEA-90S/80S
408 | CRSS-86S | SPIX-61S
409 | CRSS-87S | Super
410 | GLCO-63S
411 | GLCO-60S
412 | CRSS-69S | TWEE-60S
413 | AVSS-64S
414 | ELGC-61S
415 | PCIS-72S | ELGC-62S
416 | AVSS-81S | PBUR-60S
417 | SCOR-63S
418 | SCOR-61S
419 | ASSU-80S
420 | [NAME]
421 | MOUN-61S
422 | GLCO-61S
423 | PCIS-70S | JWIS-62S
424 | STRA-60S
425 | DAVI-68S | LOCK-63S
426 | PCIS-73S | [NAME]
427 | CECI-61S | FPAR-61S
428 | AVSS-80S | ECFI-60S
429 | NMEA-63S
430 | AVSS-60S | [NAME]
431 | ROBA-62S
432 | ROBA-72S
435 | PCIS-62S | DUNW-60S
450 | CRSS-65S | ARTS-61S
451 | CRSS-67S | CHIP-60S
452 | CRSS-64S | SCRE-60S | CRSS-94S
453 | CRSS-62S | SGRG-62S | SGRG-80S
454 | CRSS-66S | ASHO-60S
455 | CRSS-68S | JPRO-60S
456 | BANT-62S | ASHO-62S
457 | STAS-60S | ASHO-61S
458 | CRSS-63S | BSAC-60S
459 | CRSS-61S | EMCA-60S
460 | MONT-76S | ASHO-63S
461 | AVSS-62S | LOCK-60S
462 | CECI-62S | FPAR-60S
463 | JWIS-61S
464 | PCIS-61S | JWIS-60S
465 | SCOR-60S | SCOR-90S
467 | AVSS-61S | ELGC-60S
468 | PCIS-71S | [NAME]
500 | RCAR-13
501 | CCSS-26
503 | MTSS-14
504 | IDCI-62S | KNOL-60S
506 | MONT-80S | SPIX-04
507 | LDSS-60S | RIVH-60S
508 | LHAW-61S
509 | IDCI-63S | HARR-60S
510 | SMRY-64S
511 | SMRY-63S
512 | SPAW-60S
513 | MOUN-63S
514 | SMRY-81S
515 | HARR-61S
516 | MONT-85S | BYSW-60S
517 | HARR-64S
518 | SMRY-80S
519 | HPSS-61S
520 | CASS-65S
521 | CASS-73S
522 | PITT-60S
523 | ROBA-60S
524 | ROBA-70S
525 | ROBA-71S
526 | WRMA-60S
527 | WRMA-61S
528 | WRMA-62S
530 | MONT-84S | LHAW-62S
550 | SMRY-02
551 | SMRY-03
552 | IDCI-10 | SJUI-61S
553 | IDCI-60S | THAM-60S
554 | SPAW-61S
555 | SMRY-60S
556 | SMRY-61S
557 | SJUI-60S
558 | SMRY-65S
559 | HPSS-64S | CENT-60S
560 | HARR-62S
561 | HARR-63S
562 | SMRY-62S
563 | HPSS-63S | SMIW-60S
564 | CASS-60S | ALGO-60S
566 | DAVI-67S | SDOR-60S
243-MID | BANT-85S MD
244-MID | BEAL-90S MD
245-MID | MONT-90S MD
246-MID | SBER-90S MD
248-MID | OAKR-90MD
249-MID | [NAME]
278-MID | CHIP-90S MD
433-MID | CRSS-95S MD
434-MID | [NAME]
436-MID | CRSS-92S MD
502 | LAUR-08
529-MID | SPAW-90S MD
531-MID | MONT-91S MD
565-MID | SMRY-90S MD