[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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!