Max Function Refer To 1st Cell in Row

[jdo23]

I am trying to create a formula that will display the 'name' from column A that corresponds with the row of the value resulting from Max function for range in column B. To illustrate the desired results:

On 'sheet 1' I have the max function determine that cell B5 has the highest number for column B. I want the value in A5 (name associated with the row) to display on Cell C3 of 'Sheet 2'

If that make sense, can someone help?

 

[T. Valko]

I am trying to create a formula that will display the 'name' from column A that corresponds with the row of the value resulting from Max function for range in column B. To illustrate the desired results:

On 'sheet 1' I have the max function determine that cell B5 has the highest number for column B. I want the value in A5 (name associated with the row) to display on Cell C3 of 'Sheet 2'

If that make sense, can someone help?

See your other post:

http://www.mrexcel.com/forum/showthread.php?t=614280