software

How do I have a cell return a yes/no true/false answer.

I want quot;sheet-1 b1quot; to see if the same value of quot;sheet-1 a1quot; is
anywhere in quot;sheet-2 a1:a10000quot; and if so return a value of yes or
no.

Thanks

WallyIn Sheet1, B1

=IF(COUNTIF(Sheet2!A1:A10000,A1)gt;0,quot;Yesquot;,quot;Noquot;)

HTH

quot;WTGquot; wrote:

gt; How do I have a cell return a yes/no true/false answer.
gt;
gt;
gt;
gt;
gt; I want quot;sheet-1 b1quot; to see if the same value of quot;sheet-1 a1quot; is
gt; anywhere in quot;sheet-2 a1:a10000quot; and if so return a value of yes or
gt; no.
gt;
gt; Thanks
gt;
gt; Wally
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;

=isnumber(match(a1,sheet2!$a$1:$a$10000,0))

will return true if there's a match. And false if there's no match.

You could use:
=if(isnumber(match(a1,sheet2!$a$1:$a$10000,0)),quot;Ye squot;,quot;Noquot;)
if you cared about yes/no.

WTG wrote:
gt;
gt; How do I have a cell return a yes/no true/false answer.
gt;
gt; I want quot;sheet-1 b1quot; to see if the same value of quot;sheet-1 a1quot; is
gt; anywhere in quot;sheet-2 a1:a10000quot; and if so return a value of yes or
gt; no.
gt;
gt; Thanks
gt;
gt; Wally

--

Dave Peterson