Can I index/match multiple criteria in one cell?

I have a column that is a multi select dropdown of project codes.

The codes are matched with a description on another sheet. Some rows have multiple project codes in the cell that has the multi select dropdown.

Is there a way to have the description come in for each selection, not just the first?

My suggestion to the team was to use multiple columns, one for each code, then the index/match would work fine, but there would be multiple columns for the codes and the descriptions. We could then hide all the description columns and add another that concatenates them all in the right order, but there's no way around having multiple columns for each code I can think of.

Does anyone know of a solution for this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!