INDEX/COLLECT Formula for gathering list of data

Hi, I am not sure if INDEX, MATCH or COLLECT will be the right things to use in this formula but I'm very much a beginner in using those functions.

On Sheet 1 I have a massive list of Restaurants (Column 1: Restaurant Name). Also on that sheet is Column 2: Division (For example Tampa Bay Restaurant is in the Southern Division).

On Sheet 2 I have a list of those Divisions in Column 1: Division. On Sheet 2 Column 2: Restaurants in Division, is where I would like a formula that looks at Sheet 1 and collects every restaurant name that is in the Division listed on Sheet 2 Column 1.

I've done a fair bit with INDEX/MATCH functions but nothing with COLLECT yet. Anyone have any ideas on how this could be done?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!