One mo

=IF(SUM(COUNTIF(A1,"*"&{"testing","working","cold" }&"*"))0,"Yes","No")

You could actually leave the "0" out of the expression. But I think it makes
the formula easier to understand.

vinstream wrote:

Hi,

I have the following sample data in column A.

germany (testing)
Germany (cold)
Germany
Austria (Testing)
Austria (cold)
Austria (working)
Austria (other)
China
China (alternate)

In column B, I want it to show that if the cell to the left has any of
the words 'testing' or 'cold' or 'working' it should show "yes" in
Column B else show "no".

Is this possible?

Regards,

Vinstream

--

Dave Peterson