Match a1 to B1:B10, = true

K

Kikkoman

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.
 
R

Rowan

Another way you could do this:

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

Regards
Rowan
 
D

Dave Peterson

You could use your formula in a modified way (but don't use it):

=IF(OR(A1=B1:B10),"True", "")

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)


And one more:

=isnumber(match(a1,b1:b10,0))
 
Top