I'm trying to do an index(match where my search cell sometimes has multiple values (consultant column is a multi-select dropdown). I want to do an index match to report the company of that consultant or consultants. If there are two consultants they will always be from the same company. The below is returning and error. I'm not sure where to go.

=INDEX({Company}, MATCH(CONTAINS(Consultant@row, @cell), {consultant1}, 0))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!