Forum Discussion

dvspnut's avatar
dvspnut
Copper Contributor
Feb 21, 2020

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 workbook i am using is below and the page i need the formulas is called checks and balances

 

Thankyou

Resources