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.

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

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.

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 mo

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

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.

--

Dave Peterson

nice formula


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=400322