Search code examples
google-sheetsgoogle-sheets-formula

Returning Value based on multiple criteria

I am trying to return a specific value that meets all criteria.

The formula I tried but doesn't work at all is :

=INDEX(E10:E24, MATCH(A2, A10:A24& MATCH(C2,C10:C24, 0)))

In Cell D2 I would like to retrieve the score found in the EXAMPLE DB when A2 and C2 match in the EXAMPLE DB. The result in this example should display "7" from the Example DB.

Any help would be appreciated. thanks in advance!

Solution

  • Use FILTER instead:

    =FILTER(E10:E24,(A10:A24=A2)*(C10:C24=C2))

    Result:

    enter image description here