Formula - Index/Collect/Match by rank

OK, I'm stumped!

Here is my source sheet

And here is my destination sheet

What I want is...

Column: Contractor A

Return Value From: Source Sheet Company Column


  • Source Sheet, Type Column Matches Destination Sheet Category Coulmn
  • Source Sheet Rating Coulmn is the highest value.

Columns: Contractor B & Contractor C

Same as above but 2nd and 3rd highest values.

Any help, I've completely confused myself trying to work it out.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!