=IFERROR(VLOOKUP("R1M1", Results!A:H, 3, 0), "")
Set up cells to look like a bracket:
Instead of re-typing names, use a simple =IF formula to move winners forward. tournament brackets excel
If you'd like to represent the bracket using mathematical formulas, you can use a recursive function to determine the winner of each match: $$ Winner_i = \begincases Team_i & \textif Team_i \text wins \ Opponent_i & \textif Opponent_i \text wins \endcases $$ Where $i$ represents the match number, and $Team_i$ and $Opponent_i$ represent the teams playing in that match. =IFERROR(VLOOKUP("R1M1", Results