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

[EdChicago]

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. 

[#2]

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