In cell D2:
Code:
=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.