Match or Find values in one column based on another column

[slckkrky]

Hello all

I am trying to find/match/flag records that match values in one column based on another column. I tried few ways as in attached picture but I couldnot make it work. Field 2 will always have multiple (number of entry varies in that field) records with comma.

Can anyone help ?

Thank you

[LukeM · Accepted solution]

Hi @slckkrky 

The top one should work, but you need the fields the other way round.

It should be Contains( [the long field you're searching in] , [what you're searching for] )

Let me know if that works.

Luke