"bob" wrote:
"Bob Phillips" wrote:
=MAX(IF(PlayerSummary!$E$2:$E10048,
PlayerSummary!$E$2:$E$100))

This produces the highest value in column E.
I want it to produce the value in column
that is in the same row as the highest value in column AB.

Assuming there'll be no ties in the max values
we could try, array-entered (press CTRL+SHIFT+ENTER):
=INDEX(PlayerSummary!$E$2:$E$100,MATCH(MAX(IF(Play erSummary!$AB$2:$AB10048,
PlayerSummary!$AB$2:$AB$100)),PlayerSummary!$AB$2: $AB100,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---