True/False if cell contains any text in cell in entire column

[moby]

I use the following formula to show TRUE or FALSE if cell B2 is found anywhere in column A.

=IF(COUNTIF(A:A,B2),TRUE,FALSE)

This only shows TRUE if a cell in column A matches cell B2 exactly. How can I get this to show TRUE or FALSE if the cell in column A only CONTAINS the text in cell B2?

 

[T. Valko]

I use the following formula to show TRUE or FALSE if cell B2 is found anywhere in column A.

=IF(COUNTIF(A:A,B2),TRUE,FALSE)

This only shows TRUE if a cell in column A matches cell B2 exactly. How can I get this to show TRUE or FALSE if the cell in column A only CONTAINS the text in cell B2?

Try this array formula but use a smaller more specific range.

=AND(A1:A10=B2)

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

 

[AlphaFrog]

Try something like this...

=COUNTIF(A:A,"*"&B2&"*")>0

 

[T. Valko]

Try this array formula but use a smaller more specific range.

=AND(A1:A10=B2)

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Hmmm...

After seeing the other reply I may have misunderstood what you want.

My interpretation was you wanted to test to see if EVERY (used) cell in column A = B2.

 

[moby]

@AlphaFrog - Perfect - Thanks!