| A (Match#) | B (Team 1) | C (Team 2) | D (Winner) | E (Next round match#) | F (Notes) | |------------|------------|------------|------------|----------------------|-----------|
(LB) Match A (play-in): Loser goes to LB Match 1 LB Match 1: Loser(M1) vs Loser(Match A) → Winner → LB Match 5 LB Match 2: Loser(M2) vs Bye (if needed) → Winner → LB Match 5 LB Match 3: Loser(M3) vs Loser(M4) → Winner → LB Match 6 LB Match 4: Loser(M5) vs Bye → Winner → LB Match 6 LB Match 5: Winner(LB1) vs Winner(LB2) → Winner → LB Match 7 LB Match 6: Winner(LB3) vs Winner(LB4) → Winner → LB Match 7 LB Match 7: Winner(LB5) vs Winner(LB6) → Winner → LB Final LB Final: Winner(LB7) vs Loser(WB Final) → Winner → Grand Final 9 team double elimination bracket excel
In (e.g., WB Round 2 Match 5 Team 1 slot): | A (Match#) | B (Team 1) |
=IF(D2="Team A", "Team A", IF(D2="Team B", "Team B", "")) Or better: Use XLOOKUP to pull winner by match#. one more match
Example for WB Round 2, Match 5, Team 1 slot:
(if LB winner wins, one more match; if WB winner wins, tournament over).
