applying contains formula for checking values in two coulumns

Jules22

Data before formula 

Formula:
 

After Formula:



for cases like below as such as "Individuals" in one and "Entities & Individuals" in other i want Y in "Borrower Match"

same for "Entities" in one and "Entities & Individuals" in other i want Y in "Borrower Match"

binu_acs

@Jules22 you need to adjust the formula to check both ways

If contains([borrower type],[borrower type2]) or contains([borrower type2],[borrower type]) then 'Y' else 'N' 
ENDIF