Finding cells with subset of another cell

[altijani]

Hello

I have the first 2 columns on the following dataset, and I would like to obtain the third column. The third column is a "Yes" if it contains a subset of the First cell, and "No" otherwise. Thank you in advance:

Master	New	Condition_Desired
Order_UNIQ_ID	Program_Order_UNIQ_ID	Yes
PRVDR_STATE_Program_ID	Program_PRVDR_STATE_Program_ID	Yes
RCPNT_STATE_Program_ID	Program_RCPNT_STATE_Program_ID	Yes
SUBMTG_Program_LCL_STATE_CD	Program_SUBMTG_LCL_STATE_CD	No
Order_RCPNT_1ST_NAME	BENE_RCPNT_1ST_NAME	No

[Kurt_Bremser · Accepted solution]

if find(new,strip(master))
then condition_desired ="Yes";
else condition_desired ="No";