Forum Discussion
Malfunctional Formula
=IFERROR(INDEX(TRIM(ISNUMBER(SEARCH(A1,A2:A4))), MATCH(B1&"*",B2:B4,0))=TRIM(A1),"TRUE") So B Column is working perfectly. The A column is messing up though. A1=Doreen and A3=Doreen W I'm trying to...
You didn't tell about column B so I just focused on column A:
=COUNTIFS(A2:A4,"*"&A1&"*")>0