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

 |  |  | ASUN |  |  |  |  |  |  |  |  |  |  |  |  |  | AP |  |  |  | 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 | 2024-11-04 00:00:00 |  | Union (TN) | W | 95 | 75 | 30 | 62 | 0.484 | 11 | 23 | 0.478 | 24 | 26 | 0.923 | 9 | 33 | 14 | 10 | 0 | 9 | 19 |  | 25 | 54 | 0.463 | 11 | 27 | 0.407 | 14 | 25 | 0.56 | 8 | 29 | 17 | 4 | 4 | 16 | 16
 |  |  |  |  | 17.5 | 1000 |  | 147.5 |  |  |  |  |  | 2 | 2024-11-08 00:00:00 | @ | Butler | W | 68 | 66 | 28 | 62 | 0.452 | 4 | 17 | 0.235 | 8 | 14 | 0.571 | 10 | 28 | 8 | 9 | 3 | 7 | 18 |  | 21 | 49 | 0.429 | 7 | 25 | 0.28 | 17 | 19 | 0.895 | 7 | 32 | 12 | 5 | 4 | 14 | 14
 |  |  |  |  | 2.5 | 124 |  | 146.5 |  |  |  |  |  | 3 | 2024-11-11 00:00:00 |  | Chattanooga | W | 67 | 61 | 21 | 48 | 0.438 | 6 | 15 | 0.4 | 19 | 26 | 0.731 | 7 | 33 | 9 | 7 | 3 | 10 | 15 |  | 25 | 64 | 0.391 | 5 | 29 | 0.172 | 6 | 9 | 0.667 | 11 | 33 | 14 | 6 | 1 | 10 | 19
 |  |  |  |  | 28.5 | -- |  | 141 |  |  |  |  |  | 4 | 2024-11-17 00:00:00 | @ | Tennessee | L | 68 | 103 | 22 | 62 | 0.355 | 10 | 33 | 0.303 | 14 | 17 | 0.824 | 4 | 17 | 10 | 6 | 2 | 13 | 25 |  | 37 | 58 | 0.638 | 5 | 14 | 0.357 | 24 | 33 | 0.727 | 11 | 40 | 22 | 10 | 10 | 10 | 17
 |  |  |  |  | 0 | -111 |  | 137.5 |  |  |  |  |  | 5 | 2024-11-20 00:00:00 | @ | Morehead State | L | 58 | 63 | 22 | 55 | 0.4 | 5 | 16 | 0.313 | 9 | 12 | 0.75 | 7 | 29 | 11 | 7 | 3 | 8 | 19 |  | 24 | 49 | 0.49 | 2 | 13 | 0.154 | 13 | 21 | 0.619 | 7 | 32 | 10 | 3 | 4 | 9 | 12
 |  |  |  |  | 1.5 | 100 |  | 145 |  |  |  |  |  | 6 | 2024-11-26 00:00:00 | N | Georgia State | W | 62 | 50 | 20 | 50 | 0.4 | 10 | 21 | 0.476 | 12 | 19 | 0.632 | 6 | 27 | 9 | 7 | 2 | 11 | 19 |  | 15 | 39 | 0.385 | 5 | 13 | 0.385 | 15 | 23 | 0.652 | 4 | 29 | 8 | 7 | 2 | 17 | 15
 |  |  |  |  | 5 | 170 |  | 143.5 |  |  |  |  |  | 7 | 2024-11-27 00:00:00 | N | UT Arlington | L | 58 | 68 | 23 | 61 | 0.377 | 7 | 26 | 0.269 | 5 | 8 | 0.625 | 7 | 23 | 14 | 5 | 4 | 7 | 21 |  | 18 | 44 | 0.409 | 9 | 17 | 0.529 | 23 | 27 | 0.852 | 6 | 34 | 5 | 2 | 3 | 13 | 12
 |  |  |  |  | 9 | 331 |  | 137.5 |  |  |  |  |  | 8 | 2024-11-30 00:00:00 | @ | ETSU | L | 57 | 79 | 19 | 57 | 0.333 | 7 | 26 | 0.269 | 12 | 17 | 0.706 | 7 | 26 | 10 | 5 | 1 | 10 | 19 |  | 30 | 63 | 0.476 | 8 | 21 | 0.381 | 11 | 17 | 0.647 | 13 | 43 | 20 | 5 | 3 | 9 | 12
 |  |  |  |  | 13 | 650 |  | 151 |  |  |  |  |  | 9 | 2024-12-08 00:00:00 | @ | [NAME] | L | 47 | 72 | 19 | 54 | 0.352 | 2 | 17 | 0.118 | 7 | 10 | 0.7 | 8 | 30 | 8 | 8 | 2 | 16 | 13 |  | 27 | 66 | 0.409 | 11 | 31 | 0.355 | 7 | 10 | 0.7 | 15 | 38 | 18 | 11 | 6 | 12 | 11
 |  |  |  |  | 1.5 | 105 |  | 134.5 |  |  |  |  |  | 10 | 2024-12-14 00:00:00 |  | Southern Illinois | L | 60 | 65 | 19 | 48 | 0.396 | 6 | 21 | 0.286 | 16 | 24 | 0.667 | 11 | 34 | 6 | 6 | 2 | 14 | 18 |  | 24 | 56 | 0.429 | 6 | 16 | 0.375 | 11 | 17 | 0.647 | 11 | 30 | 12 | 3 | 3 | 11 | 19
 |  |  |  |  | 14 | 650 |  | 142 |  |  |  |  |  | 11 | 2024-12-18 00:00:00 | @ | Ohio | L | 58 | 78 | 17 | 45 | 0.378 | 5 | 18 | 0.278 | 19 | 34 | 0.559 | 7 | 25 | 11 | 7 | 4 | 17 | 21 |  | 26 | 50 | 0.52 | 12 | 24 | 0.5 | 14 | 19 | 0.737 | 2 | 25 | 19 | 11 | 3 | 15 | 23
 |  |  |  |  | 24.5 | 2800 |  | 143 |  |  |  |  |  | 12 | 2024-12-21 00:00:00 | @ | [NAME] | L | 55 | 85 | 19 | 60 | 0.317 | 2 | 19 | 0.105 | 15 | 22 | 0.682 | 9 | 26 | 9 | 9 | 1 | 13 | 23 |  | 29 | 48 | 0.604 | 8 | 18 | 0.444 | 19 | 27 | 0.704 | 6 | 39 | 18 | 8 | 7 | 17 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 2024-12-29 00:00:00 |  | [NAME] | W | 93 | 46 | 35 | 76 | 0.461 | 17 | 46 | 0.37 | 6 | 11 | 0.545 | 18 | 46 | 20 | 14 | 3 | 8 | 14 |  | 18 | 56 | 0.321 | 3 | 18 | 0.167 | 7 | 7 | 1 | 7 | 28 | 8 | 6 | 1 | 18 | 12
 |  |  | Yes |  | 6.5 | 235 |  | 148.5 |  |  |  |  |  | 14 | 2025-01-02 00:00:00 | @ | North Florida | W | 97 | 89 | 28 | 54 | 0.519 | 7 | 17 | 0.412 | 34 | 39 | 0.872 | 7 | 33 | 16 | 7 | 0 | 10 | 19 |  | 29 | 62 | 0.468 | 6 | 17 | 0.353 | 25 | 31 | 0.806 | 10 | 30 | 11 | 5 | 5 | 9 | 23
 |  |  | Yes |  | 6 | 211 |  | 130.5 |  |  |  |  |  | 15 | 2025-01-04 00:00:00 | @ | Jacksonville | L | 44 | 68 | 19 | 69 | 0.275 | 4 | 28 | 0.143 | 2 | 5 | 0.4 | 9 | 28 | 7 | 9 | 3 | 12 | 16 |  | 24 | 52 | 0.462 | 5 | 11 | 0.455 | 15 | 20 | 0.75 | 8 | 39 | 9 | 8 | 11 | 16 | 11
 |  |  | Yes |  | -8 | -360 |  | 131.5 |  |  |  |  |  | 16 | 2025-01-09 00:00:00 |  | West Georgia | L | 68 | 72 | 22 | 57 | 0.386 | 9 | 25 | 0.36 | 15 | 25 | 0.6 | 8 | 32 | 10 | 8 | 4 | 12 | 17 |  | 29 | 55 | 0.527 | 5 | 13 | 0.385 | 9 | 19 | 0.474 | 4 | 37 | 17 | 7 | 3 | 11 | 17
 |  |  | Yes |  | 1 | -102 |  | 145.5 |  |  |  |  |  | 17 | 2025-01-11 00:00:00 |  | Queens (NC) | L | 60 | 67 | 21 | 62 | 0.339 | 11 | 35 | 0.314 | 7 | 9 | 0.778 | 4 | 21 | 8 | 13 | 3 | 6 | 15 |  | 27 | 61 | 0.443 | 6 | 17 | 0.353 | 7 | 9 | 0.778 | 14 | 47 | 10 | 4 | 7 | 17 | 14
 | 1 |  | Yes |  | 2.5 | 130 |  | 142.5 |  |  |  |  |  | 18 | 2025-01-16 00:00:00 |  | Eastern Kentucky | W | 97 | 90 | 33 | 69 | 0.478 | 19 | 34 | 0.559 | 12 | 16 | 0.75 | 5 | 33 | 21 | 7 | 6 | 9 | 16 |  | 28 | 76 | 0.368 | 9 | 27 | 0.333 | 25 | 28 | 0.893 | 14 | 45 | 12 | 7 | 6 | 9 | 16
 |  |  | Yes |  | 15 | 850 |  | 136.5 |  |  |  |  |  | 19 | 2025-01-18 00:00:00 | @ | Lipscomb | L | 60 | 88 | 22 | 63 | 0.349 | 10 | 33 | 0.303 | 6 | 9 | 0.667 | 6 | 20 | 10 | 9 | 0 | 7 | 16 |  | 30 | 50 | 0.6 | 12 | 23 | 0.522 | 16 | 20 | 0.8 | 6 | 39 | 20 | 5 | 3 | 12 | 10
 |  |  | Yes |  | -1.5 | -115 |  | 135.5 |  |  |  |  |  | 20 | 2025-01-23 00:00:00 | @ | Central Arkansas | W | 73 | 71 | 27 | 66 | 0.409 | 9 | 22 | 0.409 | 10 | 13 | 0.769 | 8 | 30 | 15 | 9 | 3 | 5 | 12 |  | 28 | 60 | 0.467 | 9 | 24 | 0.375 | 6 | 9 | 0.667 | 8 | 36 | 15 | 5 | 7 | 11 | 15
 | 1 |  | Yes |  | 12.5 | 600 |  | 141.5 |  |  |  |  |  | 21 | 2025-01-25 00:00:00 | @ | North Alabama | L | 84 | 88 | 31 | 70 | 0.443 | 9 | 33 | 0.273 | 13 | 19 | 0.684 | 7 | 35 | 15 | 4 | 3 | 8 | 25 |  | 29 | 77 | 0.377 | 9 | 33 | 0.273 | 21 | 30 | 0.7 | 21 | 54 | 12 | 3 | 11 | 9 | 16
 | 1 |  | Yes |  | -8.5 | -418 |  | 140 |  |  |  |  |  | 22 | 2025-01-30 00:00:00 |  | Bellarmine | W | 86 | 77 | 27 | 60 | 0.45 | 8 | 27 | 0.296 | 24 | 33 | 0.727 | 13 | 42 | 14 | 3 | 1 | 12 | 16 |  | 27 | 63 | 0.429 | 7 | 22 | 0.318 | 16 | 21 | 0.762 | 8 | 30 | 6 | 6 | 1 | 8 | 23
 |  |  | Yes |  | 7.5 | 291 |  | 145.5 |  |  |  |  |  | 23 | 2025-02-01 00:00:00 | @ | Eastern Kentucky | L | 82 | 88 | 32 | 65 | 0.492 | 8 | 19 | 0.421 | 10 | 13 | 0.769 | 10 | 29 | 10 | 2 | 2 | 4 | 13 |  | 34 | 67 | 0.507 | 9 | 22 | 0.409 | 11 | 13 | 0.846 | 10 | 33 | 15 | 3 | 8 | 4 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 2025-02-05 00:00:00 |  | North Alabama
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 2025-02-08 00:00:00 |  | Central Arkansas
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 2025-02-13 00:00:00 |  | Florida Gulf Coast
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | 2025-02-15 00:00:00 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 2025-02-18 00:00:00 | @ | Bellarmine
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 2025-02-20 00:00:00 | @ | Queens (NC)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 2025-02-24 00:00:00 |  | Lipscomb
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 2025-02-26 00:00:00 | @ | West Georgia
 |  |  |  |  |  |  |  |  | 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