I am trying to write a formula in Google sheets that returns a value if 2 conditions, 1 horizontal and one vertical are met. I tried index match but it didn't work with 2 conditions

Here is a screen shot with an example:

CodePudding user response：

An alternative approach

=filter(filter(F9:K14, F9:K9=F2), E9:E14=F3)