二格互找 找到为1,找不到为0 (11172)

D2=ISNUMBER(FIND(A1,B1))+ISNUMBER(FIND(B1,A1))

另解=COUNTIF(A1,"*"&B1&"*")+COUNTIF(B1,"*"&A1&"*")

另解{=OR(COUNTIF(A2:B2,"*"&A2:B2&"*")=2)*1

多格式用 D8{=OR(COUNTIF(A8:C8,"*"&A8:C8&"*")=3)*1