Multiselect Dropdown Parsing

Hello all,

I have 3 columns in a sheet. 1 is a multi-select dropdown ("MSD"), 1 is a single contact ("SC"), and 1 is a multi-select contact ("MSC"). In the SC, I want to take the first dropdown value from the MSD and use it to index match a value from another sheet. In the MSC, then I want to take the remaining values from the MSD and index match those values individually from another sheet. I don't foresee more than 3 values in the MSD. Is this possible?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!