Returning winner of two values (teams) in range of cells

[Tacalabala]

I've got a bit stuck trying to put together the spreadsheet for whoever takes on the FPL Rugby competition next.

I want the teams for the semi finals and finals to populate automatically as the results are confirmed. To help do this, I've created GW rankings (AE) that give each team a ranking. What I need is M7 to return to winner (in ranking) between France and Argentina (it should be France as they have the higher ranking). It's stumped me and I can't even think of a way of expressing it in a way that I'll be able to find the solution on Google

[murf]

Can't you just use nested IFs?

=IF(G7>G10,E7,(IF(G10>G7,E10,"draw")))

[Tacalabala]

Can't you just use nested IFs?

=IF(G7>G10,E7,(IF(G10>G7,E10,"draw")))

That's not very automated though, using the tables allows for the breakers to be processed, which is going to happen a fair bit possibly.

[Talkie Toaster]

I'm afraid I'm using a very old version of office so I can't view your file to see exactly what you're trying to do.

Would something like this help though?

[mike_d99]

If I'm understanding what you're trying to do correctly, how about just using a VLOOKUP of the teams/rankings, combined with an IF statement to return the lowest value of the two?

=IF(VLOOKUP(F8,$AE$4:$AF$7,2,FALSE)<VLOOKUP(F11,$AE$4:$AF$7,2,FALSE),F8,F11)

[Tacalabala]

I'm afraid I'm using a very old version of office so I can't view your file to see exactly what you're trying to do.

Would something like this help though?

If I'm understanding what you're trying to do correctly, how about just using a VLOOKUP of the teams/rankings, combined with an IF statement to return the lowest value of the two?

=IF(VLOOKUP(F8,$AE$4:$AF$7,2,FALSE)<VLOOKUP(F11,$AE$4:$AF$7,2,FALSE),F8,F11)

Thanks both mike's was the solution to my issue, but your solution TT is actually fantastic for leagues going to a playoff so I'll keep hold of that