Finding max number but displaying text name

Closed
amature - Oct 27, 2009 at 12:49 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 27, 2009 at 10:23 PM
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.
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 27, 2009 at 10:23 PM
=INDIRECT("A"&MATCH(MAX(B1:B100),B1:B100,0))
0