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