Combination If Function

could you explain your request more? Your attachment shows 5 attachments and attachment dropdown in cells B2 through B6 and a pass/fail in A8.
What is/are the results you expect and where based on which dropdown?

but in your attachment you seem to be saying that, for example (cells F63 through J65 - Random Scenario 4) you have 7 Ys and 8 Ns and multiple rows with either Y or N in the same column under the attachments. So why the additional rows (rows 64 and 65), how do they factor in with row 63? AND why is Attachments 2, 3 and 5 a pass for that while 1, 2 and 4 are a fail for row 27 with the attachments listed in F27 through J29 (Random Scenario 2)?
What makes a scenario a pass vs fail?

There are 5 cells with dropdowns in them A2:A6. The maximum number of attachments in your combinations is 3.

What happens if 4+ attachments are chosen in the DDs

Can there be gaps in A2:A6... so A2 = Att 1 and a5 is Att 2; the rest are blank. Is that a Pass or a fail?

this is a little clunky and needs a helper column for it, I put that in cells G6 through G13. In that helper column I made this concatenate formula...
=D6&E6&F6 in D6 and dragged down.
then this vlookup which for more combinations you'll have to adjust...
=IFERROR(IF(AND(COUNTIF(A3:A6,"<>")=2,VLOOKUP(A3&A4,$G$6:$G$13,1,FALSE)=A3&A4),"Pass",IF(AND(COUNTIF(A3:A6,"<>")=3,VLOOKUP(A3&A4&A5,$G$6:$G$13,1,FALSE)=A3&A4&A5),"Pass",IF(AND(COUNTIF(A3:A6,"<>")=4,VLOOKUP(A3&A4&A5,$G$6:$G$13,1,FALSE)=A3&A4&A5),"Pass"))),"Fail")

I think it can be done with an array using one formula but I've had trouble writing it in the version of excel I now have.

this one works as well using the concatenate list in post#8 but is much shorter...
=IFERROR(IF(VLOOKUP(A3&A4&A5&A6,$G$6:$G$13,1,FALSE)=A3&A4&A5&A6,"Pass"),"Fail")

It appears that in order to add any of the last four attachments, attachment 1 is necessary.
The drop down for cell A3 would only display Attachment 1
The drop down for cell A4 would include the last four attachments but only if attachment 1 is chosen in cell A3, otherwise nothing is displayed
The drop down for cell A5 will display the two appropriate attachments if attachment 2 is selected in cell A4, the one appropriate attachment if attachment 3 is selected in cell A4 and will not display any options otherwise.
This avoids the customer choosing attachments that will not go together.
Note that cells C3:C4 are populated using: =SUBSTITUTE(A3," ","_") and the results are hidden by choosing white as the font color.
Note that the dropdowns in cells A4:A5 are populated using =INDIRECT(C3) and =INDIRECT(C4) respectively.
Note that lists are placed in columns N:Q
Let us know if you have any questions.