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?