Jan 20 2020 03:01 AM
A1: abc
A2: acb
A3: aaa
...
B1: 123
B2: 312
B3: 333
...
C1:C3 are words that need to be found in A1:A3 and B1:B3.
if any of the words in C1:C3 are found in A1:A3 or B1:B3 the function should return D4(or any other cell) else "no words found".
is that possible?
thank you
Jan 20 2020 03:26 AM