Find value in range and return data from another column

[McG_84]

Hi everyone

I have attached a file to make this easier. Basically I would like to search "Points Scored" (B2:W9) for the highest score (which I already have done) and when it is found return the team's name that is associated with it. Then do this for the second, third, etc. as it can be seen in the "Main" sheet. I'm thinking an index/find approach, but I just keep getting "N/A". I must be missing something. Any help would be greatly appreciated.


Thanks
McG.