[Equation Help] Searching the highest value and returning associated name?
Hi all  hopefully a relatively straight forward question who's equation I can't quite figure out. Essentially, I'm looking for a way to find the highest value in a data set, return the associated name, and then have that name appear on a dashboard. For instance:
Name Number of Learning Hours 
John Doe  20 
Jane Smith  40 
George Washington  30 
I'd like to find a formula that returns Jane Smith. I presume I'd then use that formula in the Summary function of Smartsheet to then roll into a dashboard. But I'm stuck on the initial equation. Any advice?
Best Answer

=Index({Name Ref},Match(Max({Value Ref}),{Value Ref},0))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers

=Index({Name Ref},Match(Max({Value Ref}),{Value Ref},0))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Thanks for your help! It worked perfectly!
Help Article Resources
Categories
Check out the Formula Handbook template!