Help with LARGE formula with multiple worksheets

[Guest]

Hello all. Please help me with a problem I am having. I have set up a
spreadsheet with 11 worksheets for keeping scores of 10 different events.
Sheets 1-10 are scores for individual events. Sheet 11 is a list that keeps
track of the top 3 in each category.

The indivual sheets have 5 columns. Column A is the school name, B-D are sub
scores and E is a total score. The winner's list has 3 columns, A is the
event, B needs to be the school name and C is the score. I have used the
LARGE formula to pull over the top 3 scores into Column C, but I need to find
out how to pull over the corresponding school name. Please help. Thanks.

 

[Barb Reinhardt]

Have you tried using MATCH to determine the row number of the highest score
(assuming there's only one) and then and then INDEX to get the SCHOOL name?