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"

[binuacs · Accepted solution]

@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 

[DataNath]

Hey @Jules22 - looks like you need to do the check both ways. At current, you're just checking that [Borrower Type] contains what's in [Borrower Type2], which works for the first lot. However, when there's more to the string like in the bottom example, you're not checking whether [Borrower Type2] contains what's in [Borrower Type]. To do this you can expand your expression to:

IF Contains([Borrower Type], [Borrower Type2])
OR Contains([Borrower Type2], [Borrower Type]) 
THEN "Y"
ELSE "N"
ENDIF