| Match ID | Round | Bracket | Team A | Team B | Winner | Next Match ID | |----------|--------------|-----------|--------------|--------------|--------|----------------| | 1 | WB R1 | Winners | Team 1 | Team 2 | | 8 | | 2 | WB R1 | Winners | Team 3 | Team 4 | | 8 | | 3 | WB R1 | Winners | Team 5 | Team 6 | | 9 | | 4 | WB R1 | Winners | Team 7 | Team 8 | | 9 | | 5 | WB R1 | Winners | Team 9 | Team 10 | | 10 | | 6 | WB R1 | Winners | Team 11 | Team 12 | | 10 | | 7 | WB R1 | Winners | Team 13 | Team 14 | | 11 | | 8 | WB R2 | Winners | W-M1 | W-M2 | | 14 | | 9 | WB R2 | Winners | W-M3 | W-M4 | | 14 | | 10 | WB R2 | Winners | W-M5 | W-M6 | | 15 | | 11 | WB R2 | Winners | W-M7 | Team 15 | | 15 | | 12 | WB R2 | Winners | Team 16 | Team 17 | | 16 | | 13 | WB R3 (bye) | Winners | Team 18 | - | Team 18 | 16 | | 14 | WB QF | Winners | W-M8 | W-M9 | | 17 | | 15 | WB QF | Winners | W-M10 | W-M11 | | 17 | | 16 | WB QF | Winners | W-M12 | Team 18 | | 18 | | 17 | WB SF | Winners | W-M14 | W-M15 | | 19 | | 18 | WB F (upper) | Winners | W-M16 | - | | 20 (WB Final) | | 19 | WB Final | Winners | W-M17 | W-M18 | | 21 (Grand Final)|

Simpler: Manually link cells: =F2 for winner of Match 1 into Match 8’s Team A slot. Highlight rounds where both teams are filled. Use formula: =AND(ISBLANK(TeamA)=FALSE, ISBLANK(TeamB)=FALSE) → green background.

Then starts – teams drop down after first loss. This gets complex manually. Step 4: Automate Winner Propagation with Excel Formulas In the Winner column (e.g., column F), use dropdown validation (Yes/No or Team names). Then in Team A of next matches, use =IFERROR(VLOOKUP(...)) to pull winner.