Thread
:
Match a1 to B1:B10, = true
View Single Post
#
1
Kikkoman
Posts: n/a
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.
Reply With Quote