Countif multiple criteria in text string

[Alaska1]

I am using the countif statement in the attached file. I am able to pull the word fraud from the text in column C. I need to add multiple criteria to the formula. I tried adding right after the fraud, "*dispute*" but it keeps telling me there are too many arguments.



I have listed which text I want to select under the which topic. etc, Fraud, Service.

[p45cal]

In cell D2:

=LET(x,IF(SEARCH(Words[Word],C2),Words[Type]),TAKE(FILTER(x,NOT(ISERR(x)),""),1))

Copy down.

2024-06-29_152139.jpg

I made a table of the words you're looking for and what type of case they're related to.
This table needs to be in the order so that when a comment contains 2 or more words you're looking for, the type of case you want to see as a preference comes above the others. You can add/delete rows from this table without needing to adjust the formulae.
See attached.

[Pecoflyer]

Cross post Countif mulitple criteria in text string [SOLVED]
Please read A message to forum cross posters - Excelguru

[Alaska1]

Read the cross post. Will apply for future posts. Thank you!