Hi,
I have the following in D2 which contains "David & Rose Smith
=iferror(LEFT($C2,(FIND(" ",$C2,1)-1)),C2)
I want to test for strings listed in the named range, "NOGOOD".
If none of the string are in C2, I'd like to apply above. If any of the stings in NOGOOD appear in C2, the result...