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