=IF(ISBLANK([Winner's Match W5 Loser]), "Waiting", [Winner's Match W5 Loser]) But a cleaner way? Create a hidden sheet called BracketLogic that lists, for each match, exactly where its two participants come from.
Whether you download a polished template or build a dynamic array monster from scratch, remember this: double elimination excel bracket template
Use merged cells sparingly. Instead of merging cells for a match, use horizontal borders across two adjacent cells (one for player/team A, one for player/team B). Step 2: Label Your Matches with IDs This is where most DIY brackets fail. You cannot say "Cell B12." You must say "Match W3." =IF(ISBLANK([Winner's Match W5 Loser])