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

Report
-
 Mani -
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

1 reply

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