In the cells designated for Winners Round 1, link the matchups directly to your Teams sheet using an INDEX / MATCH formula to fetch the team names based on standard seed pairings: Seed 13 vs. Seed 20 Match 2: Seed 14 vs. Seed 19 Match 3: Seed 15 vs. Seed 18 Match 4: Seed 16 vs. Seed 17 Excel Formula Example for Seed 13 slot: =INDEX(Teams!$B$2:$B$21, MATCH(13, Teams!$A$2:$A$21, 0)) Use code with caution. 4. Automating the Bracket with Excel Formulas

=IF(B3="", B2, IF(C2>C3, B2, IF(C3>C2, B3, "TBD")))

Assuming Match 1 Team A name is in C5 , Score A is in D5 , Team B name is in C7 , and Score B is in D7 : =IF(OR(ISBLANK(D5), ISBLANK(D7)), "", IF(D5>D7, C5, C7)) Use code with caution.

First, Mark needed the math. In double elimination, a team isn’t out until it loses twice. For 20 teams: