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,