Formula help needed for row and column title of high and low values

Hi I have some data which I want to find the corresponding team name and week number that a high score and low score was achieved.

I've done a lot of searching online and found a solution which I can't re-create so I'm hoping there is a simpler way.

I've attached an example below. I've filled the cells in Bold with the values I want to show.

Thanks

Originally Posted by Special-K

What happens if there's a draw? It's very difficult to output several Teams with an equal score using a formula.

With my real data it’s very very unlikely. I’ve simplified the numbers a lot for the example and in reality the values will be to 2 decimal places.

for first team
team name at E18 :
INDEX($A$1:$A$6,SUMPRODUCT(($B$3:$E$6=D18)*ROW($B$3:$E$6)))
week at F18 :
INDEX($A$2:$E$2,SUMPRODUCT(($B$3:$E$6=D18)*COLUMN($B$3:$E$6)))

for reserves
team name at E20 :
INDEX($A$1:$A$13,SUMPRODUCT(($A$10:$E$13=D20)*ROW($A$10:$E$13)))
week at F20 :
INDEX($A$9:$E$9,SUMPRODUCT(($B$10:$E$13=D20)*COLUMN($B$10:$E$13)))

INDEX($A$2:$E$2,SUMPRODUCT(($B$3:$E$6=D18)*COLUMN($B$3:$E$6)))

Many Thanks Bo and Ghozi

Great answers.

Defintely muhch simpler to understand.