I have entered a formula in the current worksheet that provides the highest
value in a column in another worksheet based on whether values in a second
column are greater than 48.

=LARGE(IF(PlayerSummary!$E$2:$E100>48,PlayerSummary!$AB$2:$AB$100),1)

Now, I want a formula in the current worksheet to return a corresponding
value from that same row (different column) in the PlayerSummary worksheet.
The value I want to return is in column E.

I tried this, but it returned a #NUM! value:

=INDEX(PlayerSummary!$E$2:$E100,MATCH(LARGE(IF(PlayerSummary!$E$2:$E100>=48,PlayerSummary!$AB$2:$AB$100),D7),PlayerSummary!$E$2:$E100,0))

Can anyone help?

Thanks,
Bob