Another way you could do this:

=IF(ISNA(VLOOKUP(A1,B1:B10,1,0)),"","True")

Regards
Rowan

"Kikkoman" wrote:

If A1 appears anywhere in B1:B10, C1= "True"

=IF(a1=(B1:B10),"True", "")

Why doesn't this work? The result will only show if A1 exactly matches B1.