I want to test 2 columns when they match certain condition.

data in on 2 sheets, the conditions values are the same on both sheets

(columns reference are determined by the drop down list ---->cell y2 and z2 : refer to 2 sheets

column reference is in SelLIST A2:C11

the formual below works when I match only 1 condition (value in X4)

I've got another condition in cell y3 I want to add to the formula, any idea how?

Thank you

=TTEST(IF(INDIRECT(VLOOKUP($X4,SelLIST!$A$2:$C$11,3,FALSE))=$X4,INDIRECT($Y$2)),

IF(INDIRECT(VLOOKUP($X4,SelLIST!$A$2:$C$11,3,FALSE))=$X4,INDIRECT($Z$2)),2,1)