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




I want "sheet-1 b1" to see if the same value of "sheet-1 a1" is
anywhere in "sheet-2 a1:a10000" and if so return a value of yes or
no.

Thanks

Wally

In Sheet1, B1

=IF(COUNTIF(Sheet2!A1:A10000,A1)0,"Yes","No")

HTH

"WTG" wrote:

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




I want "sheet-1 b1" to see if the same value of "sheet-1 a1" is
anywhere in "sheet-2 a1:a10000" and if so return a value of yes or
no.

Thanks

Wally

=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)),"Ye s","No")
if you cared about yes/no.

WTG wrote:

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

I want "sheet-1 b1" to see if the same value of "sheet-1 a1" is
anywhere in "sheet-2 a1:a10000" and if so return a value of yes or
no.

Thanks

Wally

--

Dave Peterson