How can I perform a case insensitive partial match from one column to the next? Example.
The green tree
I would like to search all the phrases in Column B with the words in Column A.
The Phrase “The green tree” in column B should be identified because the word “green” from column A was found.
The Phrase “Brown Dirt” in column B should be identified because the word “brown” from column A was found.
I’ve scoured the web looking for a solution and I haven’t found one that can be easily used without the knowledge of writing code.