I'm hoping someone can help me.

I need Excel to take a number in sheet A, and if that number appears on Sheet B, I need it to return a yes, or a true, anything really.

Any way to do this?? I can do one to one comparison, but I can't find the logical argument for "if it appears anywhere on the sheet".

Oh please help!! =)

Thanks!!

~C~