Formula Help....
I have two columns one for product description and the other for units sold (about 1000 products in total), and I want to use a sheet summary formula to return the title of the best selling product.... any ideas? ideally I do not want to use helper columns in my sheet
Best Answer

There must be a way, somehow but i don't have any idea on how to do it right now. If i've any clue i'll add another answer to the thread.
Answers

Hi Gary,
Let's assume :
 you've a "sold" column where you store the number of units sold
 you've a "desc" column next to the "sold" column where you store description
The formula would look like :
=VLOOKUP(MAX(sold:sold), sold:desc, 2)

Thanks Etienne, that does work. However I have an inherent dislike of Vlookups in Smartsheet, therefore do you know if this is possible with an index or index/collect formula?

There must be a way, somehow but i don't have any idea on how to do it right now. If i've any clue i'll add another answer to the thread.
Help Article Resources
Categories
Check out the Formula Handbook template!