Nested function 'FIND(OR)'
 

One way:

If you're just checking for the presence of at least one of the words:

=SUM(COUNTIF(A1,{"*word1*","*word2*","*word3*"})) 0


In article ,
Titoto wrote:

is there a way to use the function 'FIND(OR)' to search for multiple words
within a cell

Nested function 'FIND(OR)'
 

Countif tells me a word is within the is there, but I don't know wich word.
I would like the formula to find/search for multiple words and display the
word find.
PS. in any given cell will contain 1 of the words needed.

Thanks for your help

"JE McGimpsey" wrote:

One way:

If you're just checking for the presence of at least one of the words:

=SUM(COUNTIF(A1,{"*word1*","*word2*","*word3*"})) 0


In article ,
Titoto wrote:

is there a way to use the function 'FIND(OR)' to search for multiple words
within a cell

Nested function 'FIND(OR)'
 

Then you could use something like:


=IF(COUNTIF(A1,"*word1*"),"word1",IF(COUNTIF(A1,"* word2*"),"word2",IF(COU
NTIF("*word3*"),"word3","")))



In article ,
titoto wrote:

Countif tells me a word is within the is there, but I don't know wich word.
I would like the formula to find/search for multiple words and display the
word find.
PS. in any given cell will contain 1 of the words needed.

Thanks for your help

"JE McGimpsey" wrote:

One way:

If you're just checking for the presence of at least one of the words:

=SUM(COUNTIF(A1,{"*word1*","*word2*","*word3*"})) 0


In article ,
Titoto wrote:

is there a way to use the function 'FIND(OR)' to search for multiple
words
within a cell

Nested function 'FIND(OR)'
 

Thanks - I tried 3 words and it is working fine - I don't think 'IF' function
will allow more than 7 words and I have roughly 20.
Any idea
Again thanks
"JE McGimpsey" wrote:

Then you could use something like:


=IF(COUNTIF(A1,"*word1*"),"word1",IF(COUNTIF(A1,"* word2*"),"word2",IF(COU
NTIF("*word3*"),"word3","")))



In article ,
titoto wrote:

Countif tells me a word is within the is there, but I don't know wich word.
I would like the formula to find/search for multiple words and display the
word find.
PS. in any given cell will contain 1 of the words needed.

Thanks for your help

"JE McGimpsey" wrote:

One way:

If you're just checking for the presence of at least one of the words:

=SUM(COUNTIF(A1,{"*word1*","*word2*","*word3*"})) 0


In article ,
Titoto wrote:

is there a way to use the function 'FIND(OR)' to search for multiple
words
within a cell