True or false

[WTG]

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

 

[Guest]

In Sheet1, B1

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

HTH

 

[Dave Peterson]

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