I have a lookup field that is displaying values from a multiple select field, which I have converted into a comma-separated format.
Let’s say the values in that field (field A) are:
Cat, Dog, Antelope, Lion
I have another field (field B) that has the possibility of having at least some of the same values as the first field. It might look like:
Lizard, Elephant, Cat, Eagle
The order of the variables is, well, variable because the user may enter them in whatever order they wish.
What I need to do is evaluate whether any of the terms in field A match any of the terms in field B.
In this case, it would return true because ‘Cat’ appears in both.