Home

Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1186468%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1186468%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20a%20formula%20that%20will%20display%20a%20yes%20or%20a%20no%20if%26nbsp%3B%20certain%20data%20is%20present%20on%20a%20separate%20page%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI.e.%20I%20want%20it%20to%20see%20if%20it%20can%20find%2042%20on%20sheet%201%20in%20column%201%20and%20then%20say%20yes%20or%20no%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20workbook%20i%20am%20using%20is%20below%20and%20the%20page%20i%20need%20the%20formulas%20is%20called%20checks%20and%20balances%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThankyou%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1186468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1186487%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1186487%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F564932%22%20target%3D%22_blank%22%3E%40dvspnut%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF(COUNTIF('5%20Boards'!A%3AA%2C%24A2)%2C%22yes%22%2C%22no%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1186493%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1186493%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F564932%22%20target%3D%22_blank%22%3E%40dvspnut%3C%2FA%3E%26nbsp%3BPlease%20see%20attached.%20Changed%20the%20sheet%20%228%20Boards%22%20as%20you%20didn't%20have%20all%20room%20numbers%20in%20the%20first%20column.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20what%20you%20had%20in%20mind%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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

2 Replies
Highlighted

@dvspnut 

That could be like

=IF(COUNTIF('5 Boards'!A:A,$A2),"yes","no")
Highlighted

@dvspnut Please see attached. Changed the sheet "8 Boards" as you didn't have all room numbers in the first column. 

Is this what you had in mind?