Hi,

For the team
=INDEX($A$4:$A$93,MATCH(LARGE($B$4:$B$93,ROW(A1)), $B$4:$B$93,0))

fpr the away score
=VLOOKUP(LARGE($B$4:$B$93,ROW(A1)),$B$4:$C$93,2,FA LSE)

Drag each of the formula down 2 rows and you get the team/away score for the
2nd and 3rd largest

Mike

"Gilbo" wrote:

I have a spreadsheet with columns A - Teams, B - HomeScore, C - AwayScore. I
want find how do i find the top three scores in homescore and also pick the
relivent info from column A & column C. I can find the top 3 scores with
LARGE(B4:B93,1),LARGE(B4:B93,2),LARGE(B4:B93,3),