New field auto entry

[sam1]

How do I acomplish the following in Excel? I have a game bracket whereby Team 1 plays Team 2. The score is Team 1 (88) Team 2 (66). I want the winner to automatically proceed to the next game in the schedule without me having to type in the team name.

The bracket is drawn in Excel. In the above example A1 = Team 1 and A5 = Team 2 with the winner moving to cell C4

 

[HalfAce]

Hello sam1, welcome to the board.
Assuming you have Team 1 in A1, Team 2 in A5, and 88 In B1 and 66 in B5, and you want to display the winning team's name in C4, then this formula in C4 should work.

=INDEX(A1:A5,MATCH(MAX(B1:B5),B1:B5,0),1)

Does that help?

 

[sam1]

It certainly does, thank you very much.

 

[HalfAce]

Most welcome. Glad it helped.

 

[sam1]

Given that forumla above allows the winner of the game to move forward; what would the forumla look like that would move the loser somewhere else.

Sam set up as my original question.

Thanks, in advance.