Another one...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!