Finding max number but displaying text name

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
Ok, I am trying to find the highest number (max) in all the cells between B1:B100 when it finds that max number I then want it to grab the Name out the cell next to it, cells A1:A100 and display the name not the number. I'm having a brain fart here. who has the easy answer? And thank you.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
=INDIRECT("A"&MATCH(MAX(B1:B100),B1:B100,0))