IF cell contains TEXT from [RANGE] = TRUE

Hey guys,

So, I'm trying to check if a certain Cell contains any values that appear in a range of cells.

To break it down:
In A1:A24 there are a list of strings, one per cell (which I might add to later!)
In B1 there is a string.
In C1 I would like to check if B1 has a string that is the same as any one of the cells in range A1:A24

Ideas?


Thanks,
Tom

Perhaps

=IFERROR(LOOKUP(2^15,SEARCH(a1:a24,b1),b1),"")

hi Tom, welcome to the forum. looks like COUNTIF can help you.
this counts how many times B1 appears in A1:A24.
=COUNTIF(A1:A24,B1)

this counts how many times B1 is contained inside A1:A24
=COUNTIF(A1:A24,"*"&B1&"*")

if you need a TRUE or FALSE statement, then:
=COUNTIF(A1:A24,B1)>0

extend range if needed