What would you do if two teams have the same high score for the week?

"Andrew" wrote:

I have 12 Sheets with essentially the same data on each one of them. The
sheets are named by Teams (I.E. Andrew, Will, Shon, Jack). On each sheet I
have the following information in each column (with column headers in the
first row).

A= Week
B= Opponent
C= Team Score
D= Vs. Score
E= Difference
F= W/L/T

What I would like to dois have a formula that would return the Name of the
Team and what week the Highest Score was. I already have the formula for
figuring the Highest Score, but I can't figure out how to make the cell next
to it return the Team or Week. Can someone help me out?

Thanks in advance.