Find multiple "text" criteria and return as ""Yes" in Matrix

Try:

=IF(SUMPRODUCT((Data!$A$4:$A$20=C$4)*(Data!$C$4:$H$20=$B6)*(Data!$D$4:$I$20="Passed")),"Yes","No")

adjust ranges to suit and copy down and to next column(s).... note the last condition range is offset to the right by 1 column....

replace commas with semi-colons if needed in your version.

Note: Also Sumproduct is not the most efficient method for ranges so large. If you can add a column that identifies which header in the Data sheet the information is in, then you can use COUNTIFS which is much more efficient. See attached columns A, F and G in the Matis sheet.

In F4, formula is:

=IF(COUNTIFS(Data!$A:$A,F$4,INDEX(Data!$C:$H,0,MATCH($A6,Data!$C$3:$H$3,0)),$B6,INDEX(Data!$C:$H,0,MATCH($A6,Data!$C$3:$H$3,0)+1),"Passed"),"Yes","No")