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

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