Determine if a range contains a test string

[Innoguide]

Cell A1 has a text string in it.

the range B1:B10 contains text strings and blank cells


What formula in C1 would return TRUE if any one of the cells in B1:B10 matched the text string in A1 and return FALSE if it did not?

Thanks!

 

[circledchicken]

Hi,

Maybe try:

=ISNUMBER(MATCH(A1,B1:B10,0))

 

[T. Valko]

Cell A1 has a text string in it.

the range B1:B10 contains text strings and blank cells


What formula in C1 would return TRUE if any one of the cells in B1:B10 matched the text string in A1 and return FALSE if it did not?

Thanks!

Another one...

=COUNTIF(B1:B10,A1)>0

 

[Innoguide]

Thanks both Biff and CC - both solutions worked perfectly!

 

[T. Valko]

Thanks both Biff and CC - both solutions worked perfectly!

You're welcome. Thanks for the feedback!