關鍵字有類似字 正確找出 (13168)

D2{=IFERROR(LOOKUP(1,0/(FIND(A$2:A$12,"@"&B2)>1)/(MAX(ISNUMBER(FIND(A$2:A$12,B2))*LEN(A$2:A$12))=LEN(A$2:A$12)),A$2:A$12),"没找到")