keyword search

[Doman]

I have a column with a keyword at each row. Now I want to check, row fo
row, if any of these keywords occurs in another column.

Ex:
KEYWORD
test
alpha

COLUMN A[/B] | COLUMN
Row tow bow | FALSE
Pest test best | TRUE
Alpha beta gamma | TRUE
xor or and | FALSE

Thanks in advance

 

[fcastrofilippo]

Try using the "FIND" function. It allows you to find text within a cel
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.

Fran

 

[Doman]

The problem is that FIND only uses one word of my keywords as
reference. I want i to go through all my keywords that are listed a
once without having to use a column per keyword