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.
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