Assistance with JOIN/INDEX and COLLECT function?

Hey Community! What I'm looking to do:

I have Part Number and Key Supplier as 2 different columns. When I put in multiple part numbers (the first column), I want to return all of the associated suppliers (column 2).

Has anyone done this before?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!