Using Match Function with Multiple Contact Column

Hello, I need to lookup a value in a table when a specific contact matches. I tried using match/index, however the column containing the contacts in the lookup table allows multiple contacts which I am unable to determine how to use match with multiple contact listings.

The use case is as follows: Send an email alert to all assigned managers in a particular unit when a ticket is opened by someone in their unit.

Any assistance is appreciated,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!