Home

Can I organize If/Then answers on Sheet 1 to different headers on Sheet 2?

%3CLINGO-SUB%20id%3D%22lingo-sub-874669%22%20slang%3D%22en-US%22%3ECan%20I%20organize%20If%2FThen%20answers%20on%20Sheet%201%20to%20different%20headers%20on%20Sheet%202%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874669%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20example%2C%20is%20there%20a%20formula%20for%20Sheet%201%20where%20IF%20B2%3DYes%20AND%20C2%3D1%2C%20Then%20A2%20should%20be%20under%20a%20specific%20header%20on%20Sheet%202%3F%20The%20same%20formula%20would%20then%20be%20used%20for%20B3%2C%20B4%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-874669%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876514%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20organize%20If%2FThen%20answers%20on%20Sheet%201%20to%20different%20headers%20on%20Sheet%202%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876514%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415082%22%20target%3D%22_blank%22%3E%40EdChicago%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESo%20if%20you%20type%20this%20formula%20under%20the%20specific%20heading%20in%20sheet%202%20it%20should%20work%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(%26nbsp%3B%20AND(%26nbsp%3B%20%26nbsp%3BSheet1!B2%3D%22Yes%22%2C%26nbsp%3B%20Sheet1!C2%3D1)%2C%20Sheet1!A2%2C%20%22Criteria%20Not%20Met%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThen%20you%20copy%20this%20formula%20down%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
EdChicago
New Contributor

For example, is there a formula for Sheet 1 where IF B2=Yes AND C2=1, Then A2 should be under a specific header on Sheet 2? The same formula would then be used for B3, B4 etc. 

 

 

1 Reply

Hi @EdChicago 

 

So if you type this formula under the specific heading in sheet 2 it should work

 

=IF(  AND(   Sheet1!B2="Yes",  Sheet1!C2=1), Sheet1!A2, "Criteria Not Met")

 

Then you copy this formula down

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies