Get a value from Col A based on the max value found in Col B [Solved/Closed]

Mani - Oct 8, 2016 at 05:24 PM - Latest reply:  Mani
- Oct 9, 2016 at 12:03 AM
Hello,

Get a value from Column A based on the max value found in Column B display in Column C.
I need to get value Jill in Column C.

Name Amount
John $228.50
Mike $690.00
Peter $2.50
Steve $172.00
Karla $51.45
Jill $6,416.96
Scott $107.25
Tony $491.00
Marlene $427.00
Yelli $4,155.75
Mark $3,422.78
Marvin $1,665.20
Tom $494.75
White $311.25
Brown $946.10
Black $108.50
Nat $5.00
Will $4,369.90
Luke $9.00
Jordon $96.85

Thanks & Regards
Mani
See more 

2 replies

0
Helpful
=INDEX(A2:A21,MATCH(MAX(B2:B21),B2:B21,0))
Thank you so much...I really appreciate your quick response...