index match multiple criteria

Sacid Karacuha answered on February 24, 2024 Popularity 3/10 Helpfulness 1/10

answer index match multiple criteria

Comment

=INDEX(E5:E11,MATCH(1,(H5=B5:B11)*(H6=C5:C11)*(H7=D5:D11),0))

Popularity 3/10 Helpfulness 1/10 Language whatever

Source: exceljet.net

Tags: criteria index-match whatever

Link to this answer
Share Copy Link

Contributed on Feb 24 2024

Sacid Karacuha

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.