I have a column with a keyword at each row. Now I want to check, row for row, if any of these keywords occurs in another column.
Column A | Column B
Row tow bow | FALSE
Pest test best | TRUE
Alpha beta gamma | TRUE
xor or and | FALSE
Thanks in advance!
I would use the find function
Try using the "FIND" function. It allows you to find text within a cell with text.
If the text is not found it returns a #Value.
Then use the "ISERR" function to determine if you have a match.
You may need to use more than one column to get the result you want.
Hope this helps.
FIND is to weak
The problem is that FIND only uses one word of my keywords as a reference. I want i to go through all my keywords that are listed at once without having to use a column per keyword.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1