Formula Help....

Gary Thornton

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

Etienne Mermillod

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.

Etienne Mermillod

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)

Gary Thornton

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?

Etienne Mermillod

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.