Find a specific word in a comment if it is into a list with a formula in an excel report

In some specific occasions, I have to display the correct value if I find a particular word inside a comment but only if this word is listed.

formula excel


When I use the formula ?

To find the specific word inside a comment only if it is listed.


How to use the formula ?

The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".


How are the formula ?






This formula is telling me if in the cell B2, the words BR, CL or AR is listed in the column A.

Interesting Management