Excel Formula

I want a formula that will display a yes or a no if  certain data is present on a separate page   I.e. I want it to see if it can find 42 on sheet 1 in column 1 and then say yes or no   The workb...