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 ?

=IF()

=SUMPRODUCT()

=ISNUMBER()

=SEARCH()

=IF(SUMPRODUCT(--ISNUMBER(SEARCH($A$2:$A$4,B2))),"yes","no")

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

Interesting Topics