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,

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!