If Contains

Johmz

Hi,

I need help for formula or syntax on how to identify if the column2 is equal to column1 or if column1 contains of what information that i have in column2.

see example

Professional	Personal	Status
Attorney John Doe	John Doe	Same Person
Engineer Jane Doe	Janine Doe	Different Person
Doctor Mark Dave	Mark Dave	Same Person

cjaneczko

You can use the following. 

if REGEX_Replace([Professional], '\b\w+\s([A-Z][a-z]+ [A-Z][a-z]+)\b', '$1')=[Personal] then 'Same Person' Else 'Different Person' endif