Spreadsheet: 888327d1738830710-dynamic-indirect-lookup-formula-example-2
Sheet: Alb

 |  |  | Am. East |  |  |  |  |  |  |  |  |  |  |  |  |  | Alb |  |  |  | TEAM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OPPONENT
Rest | OT? | [NAME] | Conf | P PD | PBL | ML | O/U PD | O/U | TOT | PBL | ML | O/U | PD | G | Date | [NAME] | Opp | W/L | Tm | Opp | FG | FGA | FG % | 3P | 3PA | 3P% | FT | FTA | FT% | ORB | TRB | AST | STL | BLK | TOV | PF |  | FG | FGA | FG % | 3P | 3PA | 3P% | FT | FTA | FT% | ORB | TRB | AST | STL | BLK | TOV | PF
200 |  |  |  |  | 1.5 | 105 |  | 143.5 |  |  |  |  |  | 1 | 2024-11-04 00:00:00 | @ | Army | L | 59 | 67 | 22 | 60 | 0.367 | 4 | 24 | 0.167 | 11 | 16 | 0.688 | 5 | 30 | 11 | 8 | 2 | 9 | 24 |  | 22 | 50 | 0.44 | 5 | 17 | 0.294 | 18 | 28 | 0.643 | 7 | 36 | 11 | 4 | 3 | 12 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2024-11-09 00:00:00 |  | SUNY-Oneonta | W | 89 | 69 | 38 | 80 | 0.475 | 6 | 23 | 0.261 | 7 | 14 | 0.5 | 16 | 38 | 15 | 10 | 3 | 5 | 27 |  | 24 | 48 | 0.5 | 3 | 11 | 0.273 | 18 | 32 | 0.563 | 4 | 28 | 12 | 4 | 4 | 15 | 16
 |  |  |  |  | 4 | 179 |  | 150 |  |  |  |  |  | 3 | 2024-11-13 00:00:00 | @ | Dartmouth | W | 87 | 73 | 33 | 74 | 0.446 | 10 | 31 | 0.323 | 11 | 14 | 0.786 | 12 | 34 | 14 | 9 | 1 | 5 | 23 |  | 24 | 47 | 0.511 | 3 | 12 | 0.25 | 22 | 31 | 0.71 | 4 | 31 | 10 | 2 | 2 | 15 | 17
 |  |  |  |  | -4 | -198 |  | 147 |  |  |  |  |  | 4 | 2024-11-16 00:00:00 |  | Siena | W | 70 | 60 | 24 | 52 | 0.462 | 3 | 8 | 0.375 | 19 | 24 | 0.792 | 9 | 33 | 5 | 10 | 1 | 11 | 17 |  | 21 | 58 | 0.362 | 8 | 24 | 0.333 | 10 | 13 | 0.769 | 11 | 25 | 11 | 7 | 5 | 14 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 2024-11-22 00:00:00 | N | Puerto Rico–Mayaguez | W | 93 | 50 | 34 | 61 | 0.557 | 15 | 28 | 0.536 | 10 | 16 | 0.625 | 11 | 42 | 20 | 12 | 2 | 15 | 25 |  | 17 | 50 | 0.34 | 5 | 19 | 0.263 | 11 | 23 | 0.478 | 7 | 19 | 4 | 4 | 1 | 19 | 13
 |  |  |  |  | 2 | 108 |  | 142.5 |  |  |  |  |  | 6 | 2024-11-23 00:00:00 | N | Kansas City | W | 67 | 65 | 23 | 48 | 0.479 | 5 | 19 | 0.263 | 16 | 23 | 0.696 | 4 | 16 | 11 | 9 | 0 | 8 | 22 |  | 19 | 45 | 0.422 | 9 | 27 | 0.333 | 18 | 29 | 0.621 | 11 | 35 | 14 | 3 | 3 | 14 | 19
 |  |  |  |  | -1 | -112 |  | 135 |  |  |  |  |  | 7 | 2024-11-24 00:00:00 | N | American | L | 77 | 81 | 27 | 60 | 0.45 | 4 | 13 | 0.308 | 19 | 26 | 0.731 | 8 | 25 | 8 | 4 | 0 | 10 | 21 |  | 29 | 45 | 0.644 | 9 | 16 | 0.563 | 14 | 24 | 0.583 | 4 | 24 | 13 | 3 | 7 | 16 | 25
 |  |  |  |  | 14 | 775 |  | 147.5 |  |  |  |  |  | 8 | 2024-11-30 00:00:00 | @ | Georgetown | L | 68 | 100 | 20 | 56 | 0.357 | 7 | 22 | 0.318 | 21 | 24 | 0.875 | 7 | 21 | 6 | 14 | 1 | 17 | 14 |  | 41 | 65 | 0.631 | 9 | 22 | 0.409 | 9 | 9 | 1 | 6 | 33 | 26 | 12 | 3 | 15 | 17
 |  |  |  |  | 4.5 | 182 |  | 155 |  |  |  |  |  | 9 | 2024-12-04 00:00:00 |  | Columbia | W | 88 | 73 | 32 | 67 | 0.478 | 15 | 33 | 0.455 | 9 | 12 | 0.75 | 9 | 29 | 20 | 15 | 1 | 11 | 20 |  | 24 | 46 | 0.522 | 6 | 14 | 0.429 | 19 | 26 | 0.731 | 5 | 28 | 16 | 8 | 0 | 19 | 12
 | 1 |  |  |  | 1 | 101 |  | 138.5 |  |  |  |  |  | 10 | 2024-12-07 00:00:00 | @ | Boston University | L | 74 | 80 | 26 | 62 | 0.419 | 11 | 22 | 0.5 | 11 | 14 | 0.786 | 5 | 20 | 13 | 11 | 2 | 9 | 21 |  | 28 | 52 | 0.538 | 9 | 24 | 0.375 | 15 | 26 | 0.577 | 10 | 38 | 16 | 7 | 10 | 17 | 15
 |  |  |  |  | 12.5 | 625 |  | 156.5 |  |  |  |  |  | 11 | 2024-12-10 00:00:00 | @ | Syracuse | L | 85 | 102 | 32 | 70 | 0.457 | 10 | 28 | 0.357 | 11 | 19 | 0.579 | 10 | 24 | 18 | 9 | 0 | 4 | 18 |  | 40 | 63 | 0.635 | 6 | 15 | 0.4 | 16 | 18 | 0.889 | 8 | 33 | 23 | 1 | 3 | 11 | 14
 |  |  |  |  | -2.5 | -144 |  | 144.5 |  |  |  |  |  | 12 | 2024-12-14 00:00:00 |  | Drexel | L | 70 | 77 | 27 | 57 | 0.474 | 2 | 19 | 0.105 | 14 | 15 | 0.933 | 7 | 17 | 10 | 10 | 1 | 11 | 19 |  | 25 | 41 | 0.61 | 6 | 11 | 0.545 | 21 | 26 | 0.808 | 6 | 26 | 12 | 5 | 3 | 17 | 15
 |  |  |  |  | 3.5 | 136 |  | 154.5 |  |  |  |  |  | 13 | 2024-12-18 00:00:00 | @ | [NAME] | W | 74 | 66 | 30 | 77 | 0.39 | 6 | 25 | 0.24 | 8 | 11 | 0.727 | 15 | 41 | 14 | 5 | 2 | 7 | 11 |  | 26 | 65 | 0.4 | 5 | 23 | 0.217 | 9 | 10 | 0.9 | 8 | 35 | 12 | 3 | 5 | 9 | 15
 |  |  |  |  | 6.5 | 230 |  | 154.5 |  |  |  |  |  | 14 | 2024-12-21 00:00:00 | @ | [NAME] | L | 83 | 87 | 31 | 63 | 0.492 | 7 | 16 | 0.438 | 14 | 18 | 0.778 | 8 | 34 | 17 | 5 | 2 | 15 | 19 |  | 30 | 60 | 0.5 | 9 | 19 | 0.474 | 18 | 23 | 0.783 | 5 | 29 | 18 | 11 | 7 | 12 | 14
 |  |  |  |  | -9 | -410 |  | 149.5 |  |  |  |  |  | 15 | 2024-12-29 00:00:00 |  | [NAME] | W | 77 | 70 | 27 | 51 | 0.529 | 6 | 24 | 0.25 | 17 | 20 | 0.85 | 7 | 31 | 15 | 7 | 3 | 15 | 18 |  | 24 | 61 | 0.393 | 6 | 19 | 0.316 | 16 | 21 | 0.762 | 12 | 30 | 10 | 7 | 0 | 12 | 17
 |  |  | Yes |  | 1 | 103 |  | 160.5 |  |  |  |  |  | 16 | 2025-01-04 00:00:00 |  | UMass-Lowell | L | 69 | 73 | 30 | 74 | 0.405 | 2 | 18 | 0.111 | 7 | 14 | 0.5 | 16 | 41 | 7 | 4 | 2 | 4 | 15 |  | 27 | 56 | 0.482 | 4 | 22 | 0.182 | 15 | 17 | 0.882 | 4 | 29 | 9 | 4 | 9 | 6 | 12
 |  |  | Yes |  | -11.5 | -650 |  | 145.5 |  |  |  |  |  | 17 | 2025-01-09 00:00:00 | @ | New Hampshire | W | 61 | 57 | 22 | 52 | 0.423 | 3 | 17 | 0.176 | 14 | 18 | 0.778 | 8 | 33 | 3 | 4 | 4 | 16 | 9 |  | 23 | 59 | 0.39 | 5 | 23 | 0.217 | 6 | 6 | 1 | 5 | 25 | 9 | 9 | 3 | 11 | 15
 |  |  | Yes |  | 4.5 | 165 |  | 143 |  |  |  |  |  | 18 | 2025-01-11 00:00:00 | @ | Maine | L | 66 | 87 | 25 | 58 | 0.431 | 5 | 18 | 0.278 | 11 | 17 | 0.647 | 13 | 36 | 15 | 4 | 2 | 18 | 16 |  | 31 | 55 | 0.564 | 11 | 23 | 0.478 | 14 | 18 | 0.778 | 2 | 22 | 24 | 11 | 5 | 9 | 15
 |  |  | Yes |  | 3 | 136 |  | 160.5 |  |  |  |  |  | 19 | 2025-01-16 00:00:00 |  | Bryant | L | 79 | 89 | 30 | 68 | 0.441 | 8 | 21 | 0.381 | 11 | 13 | 0.846 | 10 | 32 | 10 | 6 | 2 | 9 | 19 |  | 33 | 65 | 0.508 | 7 | 22 | 0.318 | 16 | 19 | 0.842 | 10 | 37 | 18 | 7 | 9 | 9 | 11
 |  |  | Yes |  | -2 | -138 |  | 146.5 |  |  |  |  |  | 20 | 2025-01-18 00:00:00 | @ | [NAME] | W | 70 | 65 | 22 | 51 | 0.431 | 7 | 26 | 0.269 | 19 | 25 | 0.76 | 9 | 28 | 9 | 15 | 2 | 10 | 13 |  | 24 | 50 | 0.48 | 9 | 20 | 0.45 | 8 | 11 | 0.727 | 8 | 25 | 13 | 4 | 4 | 17 | 16
 | 1 |  | Yes |  | -4 | -190 |  | 161.5 |  |  |  |  |  | 21 | 2025-01-23 00:00:00 |  | UMBC | L | 87 | 92 | 31 | 78 | 0.397 | 9 | 27 | 0.333 | 16 | 26 | 0.615 | 17 | 38 | 15 | 9 | 1 | 8 | 27 |  | 28 | 48 | 0.583 | 5 | 15 | 0.333 | 31 | 44 | 0.705 | 4 | 37 | 13 | 6 | 7 | 16 | 19
 |  |  | Yes |  | -12 | -899 |  | 139 |  |  |  |  |  | 22 | 2025-01-25 00:00:00 |  | NJIT | W | 68 | 62 | 21 | 49 | 0.429 | 5 | 17 | 0.294 | 21 | 28 | 0.75 | 8 | 30 | 11 | 4 | 3 | 9 | 12 |  | 25 | 61 | 0.41 | 3 | 19 | 0.158 | 9 | 12 | 0.75 | 12 | 35 | 9 | 3 | 2 | 8 | 21
 |  |  | Yes |  | -6.5 | -296 |  | 143.5 |  |  |  |  |  | 23 | 2025-02-01 00:00:00 |  | [NAME] | L | 61 | 65 | 25 | 61 | 0.41 | 5 | 24 | 0.208 | 6 | 7 | 0.857 | 6 | 25 | 15 | 13 | 4 | 11 | 17 |  | 22 | 47 | 0.468 | 5 | 13 | 0.385 | 16 | 21 | 0.762 | 8 | 33 | 11 | 5 | 6 | 18 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 2025-02-06 00:00:00 | @ | Bryant
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 2025-02-08 00:00:00 |  | Vermont
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 2025-02-13 00:00:00 | @ | UMass-Lowell
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | 2025-02-20 00:00:00 |  | Maine
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 2025-02-22 00:00:00 |  | New Hampshire
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 2025-02-27 00:00:00 | @ | UMBC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 2025-03-01 00:00:00 | @ | NJIT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 2025-03-04 00:00:00 | @ | Vermont
 |  |  |  |  |  |  |  |  | TOT |  |  |  |  |  |  |  |  |  | Tm | Opp | FG | FGA | FG % | 3P | 3PA | 3P% | FT | FTA | FT% | ORB | TRB | AST | STL | BLK | TOV | PF |  | FG | FGA | FG % | 3P | 3PA | 3P% | FT | FTA | FT% | ORB | TRB | AST | STL | BLK | TOV | PF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Away
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Home
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nuetral
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OOC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OOC, [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OOC, Home
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Conf
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Conf, [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Conf, Home