View Single Post
  #1   Report Post  
Kikkoman
 
Posts: n/a
Default Match a1 to B1:B10, = true

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.