I am trying to create a formula that will associate tags with a given row if that row contains text that matches entries in a row from another table.
For example, we have a table that contains a set of emails received:
Lisa spoke to a at b company
Kyle spoke to c at d company
Judy spoke to e at f company
Another table contains a list of names such as:
I want to create a field on the messages table that will show Judy and Kyle as associated tags for that message because the strings Kyle and Judy match the entries in the list of names.
Appreciate any help!