Lookup from a multi-select column, find (collect) all matching values

MCorbin Overachievers Alumni

Not sure if this is possible, but if it is, this group would know!

I'm trying to lookup from my Requesting Department Column, which is a multi-select column, to another sheet that has the department head for each department, so that I can list their names in the "Responsible for" column (contact column).

If there's only 1 department listed, I can pull the name with an Index/Match.... but is there any way to collect all the names if there are multiple departments?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!