If a range contains

[Caroline]

I'm trying to write a logical test that means: if (any cell in range a:a)

 

[Jacob Skaria]

=IF(COUNTIF(A:A,"*the word text*"),"text found","Text not found")

If this post helps click Yes