Spreadsheet: 793423d1661455517-trying-to-make-an-index-match-formula-dynamic-bo_test
Sheet: Sheet1

Angels | Angels | Angels | Angels | Angels | Angels | Angels | Angels |  | Astros | Astros | Astros | Astros | Astros | Astros | Astros | Astros |  |  | Desired Results
UIG | NAME | BO | POS |  | UIG | NAME | BO |  | UIG | NAME | BO | POS |  | UIG | NAME | BO |  |  | Team: |  |  | Lineup
68AndVelSSLVAN | [NAME] |  |  |  | 68AndVelSSLVAN | [NAME] | 10 |  | 80AleDiaSSLVHO | Aledmys Diaz | 1 | C |  | 66J.JMat1BLVHO | [NAME] | 10 |  |  |  |  |  | BO | Player | POS
81DavFleSSLVAN | [NAME] | 1 | SS |  | 64DilThoRFLVAN | Dillon Thomas | 11 |  | [NAME] | [NAME] | 3 | 1B |  | 69JakMeyCFLVHO | [NAME] | 11 |  |  | 1 |  |  | 1 | Aledmys Diaz | C
64DilThoRFLVAN | Dillon Thomas |  |  |  | 68Jo AdeRFLVAN | [NAME] | 12 |  | 80ChaMcCCFLVHO | [NAME] | 5 | 2B |  | 81JerPenSSLVHO | [NAME] | 12 |  | Yuli Gurriel | 2 |  |  | 2 | Yuli Gurriel | RF
69JarWal1BLVAN | [NAME] | 5 | 1B |  | 63JosRoj3BLVAN | [NAME] | 13 |  | 81ChrVazCALVHO | [NAME] | 7 | 3B |  | 64JoePer3BLVHO | [NAME] | 13 |  | [NAME] | 3 |  |  | 3 | [NAME] | 1B
68Jo AdeRFLVAN | [NAME] |  |  |  | 67KurSuzCALVAN | [NAME] | 14 |  | 66J.JMat1BLVHO | [NAME] |  |  |  | 86JosAlt2BLVHO | [NAME] | 14 |  | [NAME] | 4 |  |  | 4 | [NAME] | CF
63JosRoj3BLVAN | [NAME] |  |  |  | 68MagSieCFLVAN | [NAME] | 15 |  | 69JakMeyCFLVHO | [NAME] |  |  |  | 73KorLeeCALVHO | [NAME] | 15 |  | [NAME] | 5 |  |  | 5 | [NAME] | 2B
67KurSuzCALVAN | [NAME] |  |  |  | 63MatTha1BLVAN | [NAME] | 16 |  | 81JerPenSSLVHO | [NAME] |  |  |  | 87KylTucRFLVHO | [NAME] | 16 |  | [NAME] | 6 |  |  | 6 | [NAME] | LF
72LuiRen2BLVAN | [NAME] | 2 | 2B |  | 61MicMonCFLVAN | [NAME] | 17 |  | 64JoePer3BLVHO | [NAME] |  |  |  | 70MarMalCALVHO | [NAME] | 17 |  | [NAME] | 7 |  |  | 7 | [NAME] | 3B
68MagSieCFLVAN | [NAME] |  |  |  | 67PhiGos3BLVAN | [NAME] | 18 |  | 86JosAlt2BLVHO | [NAME] |  |  |  | 73MauDubCFLVHO | [NAME] | 18 |  | [NAME] | 8 |  |  | 8 | [NAME] | SS
63MatTha1BLVAN | [NAME] |  |  |  |  |  |  |  | 73KorLeeCALVHO | [NAME] |  |  |  | 72NikGooSSLVHO | [NAME] | 19
73MaxStaCALVAN | [NAME] | 6 | C |  |  |  |  |  | 87KylTucRFLVHO | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Bench
69MicSte2BLVAN | [NAME] | 8 | 3B |  |  |  |  |  | 70MarMalCALVHO | [NAME] |  |  |  |  |  |  |  |  | 10 |  |  | 10 | [NAME]
61MicMonCFLVAN | [NAME] |  |  |  |  |  |  |  | 73MauDubCFLVHO | [NAME] |  |  |  |  |  |  |  | [NAME] | 11 |  |  | 11 | [NAME]
92MikTroCFLVAN | [NAME] | 3 | CF |  |  |  |  |  | 72NikGooSSLVHO | [NAME] |  |  |  |  |  |  |  | [NAME] | 12 |  |  | 12 | [NAME]
67PhiGos3BLVAN | [NAME] |  |  |  |  |  |  |  | 60TayJon1BLVHO | [NAME] | 8 | SS |  |  |  |  |  | [NAME] | 13 |  |  | 13 | [NAME]
70SteDugCFLVAN | [NAME] | 7 | LF |  |  |  |  |  | 75TreMan1BLVHO | [NAME] | 6 | LF |  |  |  |  |  | [NAME] | 14 |  |  | 14 | [NAME]
78TayWarRFLVAN | [NAME] | 4 | RF |  |  |  |  |  | 90YorAlvLFLVHO | [NAME] | 4 | CF |  |  |  |  |  | [NAME] | 15 |  |  | 15 | [NAME]
 |  |  |  |  |  |  |  |  | 72YulGur1BLVHO | Yuli Gurriel | 2 | RF |  |  |  |  |  | [NAME] | 16 |  |  | 16 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 17 |  |  | 17 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 18 |  |  | 18 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 19 |  |  | 19 | [NAME]