Hi

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 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.

Thanks!