Hi… Here’s my scenario
Table 1 has one column called Tags and has multiple single word values
Table 2 has the columns: Phrase, Primary, Secondary and Tertiary.
Primary, Secondary and Tertiary are linked records and contain tags from Table 1. Multiple tags exist in each column
I need a formula that checks if primary, secondary and tertiary has common values.