EXCEL function

[BHSCanners]

I have used MAX to put out the largest number in a range. However, I would like Excel to give me the text information to the left that is associated with that highest number. Is there a function that can do this?

 

[Jonmo1]

Welcome to the board.

If numbers are in say B2:B10, and the associated TEXT value you want is in A2:A10

=INDEX(A2:A10,MATCH(MAX(B2:B10),B2:B10,0)

 

[BHSCanners]

Thank you. I understand the logic up until the last part of the equation -- B2:B10,0 -- Am I correct -- the B2:B10 is the range that must match with the max range and the 0 means return the first value that is equal to the max function?

 

[Jonmo1]

I left off an ending )

It should be
=INDEX(A2:A10,MATCH(MAX(B2:B10),B2:B10,0))

The 0 is the 3rd argument of the MATCH, which makes it look for an EXACT match.