Hope some one can help me.
I have a list of nearly 1million lines of text in two columns.
Column A contains URLs
Column B contains Keywords which wear searched in google to return the URL.
I'm looking to search the text in column B and compare with the text in column A to try to find matching text.
For example;
Screen Shot 2014-06-21 at 10.49.58.png
C1: TRUE as the word "footasylum" in cell B1 is also found in cell A1
C2: TRUE as the word "footwear" in cell B2 is also found in cell A2
C3: TRUE as the word "nike" in cell B3 is also found in cell A3
C4: FAULSE as the neither the word "Fashion" nor "Sportswear" in cell B4 is found in cell A4.
I'm struggling to find the right formula. I've looked a LOOKUP, VLOOKUP, SEARCH, FIND, etc. but not sure what I'm doing.
One of the main issues is that in the URL column A the words are not separate to the rest of the text in the cell (i.e. they are surrounded by "http://www." & ".com" for example.
Any help would be really appreciated.
Bookmarks