If you have the word "Tree" in column A, I want to find that same word in column B.
If the word is in Column A and B the formula must give me a result.... for example True
If it is only in one column it should give me a result.... for example False.
Or even if part of a word can be found in both columns the formula should say True.
For example in column A is "Tree" and in column B is "Tree House" it should also give me the result True.
Hope this is clear.
Thank you for your help I appreciate it.