"bob" wrote:
> > "Bob Phillips" wrote:
> > =MAX(IF(PlayerSummary!$E$2:$E100>48,
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(PlayerSummary!$AB$2:$AB100>48,
PlayerSummary!$AB$2:$AB$100)),PlayerSummary!$AB$2:$AB100,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---