How do I copy text from one cell to another cell based on the value of a third cell?

[TravisBickle09]

I apologize for the noob question as I’m a very basic user of Calc. I don’t even know where to begin to look for an answer to my question as I don’t know which functions to use.

I am the administrator for a dart league. I have a playoff bracket set up in Calc. I’ve already applied some conditional formatting to cells depending on who won or lost the match.

I would like to copy the winner’s name from one bracket to another. For example, in the top bracket of the screenshot, I want to copy the winners name from either B10 or B11 to F12 (the purple cell) based on the value in either C10 or C11. A winning score is >=3. A losing score is <=2.

In the lower bracket, I want to copy the winner’s name to F13 (the orange bracket).

Please provide a solution or tell me which functions I should be looking at. Thanks for your help.

[EarnestAl]

Maybe something like =IFS(C10>=3;B10;C11>=3;B11;AND(C10<3;C11<3);"")

[TravisBickle09]

@EarnestAl

=IFS(C10>=3;B10;C11>=3;B11;AND(C10<3;C11<3);"")

It works!! I knew it must be some sort of nested IF function, but I couldn’t find any other examples of the same problem.

Thanks very much for the swift answer to my question!

[EarnestAl]

It could be done with nesting IF but IFS works without nesting

[TravisBickle09]

The function to copy the text works but it has disabled the conditional formatting rules that colour the cell depending on the score. Oh well, another rabbit hole to go down, er, problem to solve.

[karolus]

Hallo

F12⇒
=INDEX( B10:B11;  MATCH( MAX(C10:C11); C10:C11; 0 ) )

F13⇒
=INDEX( B14:B15;  MATCH( MAX(C14:C15); C14:C15; 0 ) )

[TravisBickle09]

Thank you very much for the alternate solution.