=COUNTIF(B1:B10,A1)0

--
Regards,

Peo Sjoblom

(No private emails please)


"Kikkoman" wrote in message
...
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.