Select email if their department is contained in field

I have a simple table named "Admins" that has a field with the persons name and another field for which department they are in. I have another table named "Notifications" that depending on the type of notification it makes a list of which departments that should be notified. Here is an example

Event = New employee                            Notify = "Security, HR, Safety, IT"

My code looks like this

select(admins[email], [Department] = contains(notifications[notify dept], admins[Department]))

Code is good but doesn't return any results. Any ideas on how I can do this?

0 4 227
4 REPLIES 4