How to use index and match with two columns?

I have the following caseenter image description here

E.g., I want the two cells in yellow to be the same. For this, I need to find the columns Score 1 and Result, and then find the row 03-Jan so that I get the actual score. Do you have any idea how to solve this? I tried with some match and index but I do not get the solution.

>Solution :

Use INDEX with three matches, the first to find the correct row, while the other 2 find the correct column.


Leave a Reply