18 Team Double Elimination Bracket Excel [patched] Jun 2026

=IF(AND(B2<>"",B3<>""),"Winner", "")

You will create a 32-slot bracket. 14 of those slots will be "Byes" (empty). The Byes must be seeded against the top-ranked teams. 18 team double elimination bracket excel

Example: For Match 8, Team A formula: =VLOOKUP(8, MatchesTable, 6, FALSE) but careful – you need to store winner of Match 1. Better: Create a named range Matches (A:G). Then in cell for Team A of Match 8: =IFERROR(INDEX(Matches[Winner], MATCH(8, Matches[Next Match ID], 0)), "") – adjust based on your layout. Team A formula: =VLOOKUP(8

Rather than rebuilding from scratch, I recommend downloading a verified from: Matches[Next Match ID]

In Column D, use the following formula to determine the loser of each game:

A double elimination bracket for 18 teams usually requires to determine a winner without byes in the later rounds.