是否有一个公式（或某事），我可以用来从公式得到答案的同一行获取信息

I have 2 work sheets. One where the raw data is entered and one that is a summary page. It tracks scores in 4 sporting events with the student name and school name. I have the rank of their score so I can get 1st, 2nd, 3rd etc even with ties and no skipping over the rank number if there is a tie so you see 1,2,2,3,4.... I have the top 7 scores go to the summary page for each event. What I need to do is take the name of the student and the school, and bring it with their score to the summary page. I have limited skill in excel 2010 (that is what I am using. No skill what so ever in VBA or sql or any of that type of coding. I am hoping there is a formula that will allow me to get the school and name of the student from the area where the score came from. I hope I'm not too confusing with this.I have 2 work sheets. One where the raw data is