Finding max number but displaying text name

Closed
amature - 27 Oct 2009 à 12:49
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 27 Oct 2009 à 22:23
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 14 June 2009 Status Contributor Last seen 7 August 2021 811
27 Oct 2009 à 22:23
=INDIRECT("A"&MATCH(MAX(B1:B100),B1:B100,0))