OR Formula

Hi looking for a formula to accomplish the follow.

I have two fields that I want to search for the matching value in an array of items on another sheet. If either is within the other table I want it to return Yes or True .

For Example:  IF A2 = 'Sheet1!' A:A or B2 = 'Sheet1!' A:A, True, False

Please help.  Thank you!