Formula to give a yes/no answer based on chart

Good Morning,

I hope someone will be able to assist me with this issue. I'm trying to build a formula that'll look at a cell and if it contains an item from a list then the cell the formula is located will indicate "yes" if not then "no". Also if the cell being queried has no information then the cell with the formula stays blank.

=IF(B2=Sheet3!A1:A51,"yes","no")

here is the formula I have so far populating my J2 cell. My current tests get a no result regardless of the information that I put into the B2 cell.

Thank you for any assistance

Taron

Wow, that works perfectly

thank you so much for your help