'excel formula to select column values based on two conditions

I want to select the values column values corresponding to 0% and Bravo, so I want the values 0.939958, 0,067266 etc. Could someone help me out to select the values? I have tried this:

=CHOOSE(MATCH((L2=B2:J2)*(L3=B3:J3);0);B4:B21;C4:C21;D4:D21;E4:E21;F4:F21;G4:G21;H4:H21;I4:I21;J4:J21)

But this did not work..

Kind regards.

excel excel-formula

Solution 1:^[1]

With ms365, try:

Formula in K3:

=INDEX(FILTER(A3:I12,A2:I2=K2),0,1+K1*2)

Note that I just used RANDARRAY() to fill the matrix with sample data.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	JvdV

'excel formula to select column values based on two conditions

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]