Hi

I am trying to look up a value in a table based on two criteria using a combination of Index and Match function but it doesn't work. Could someone please have a look see where it went wrong?

In the attached file, there are two big tables. The first table is where I am trying to find the criteria in. If you click on the formula in the last column of the second table below, it should be quite self-explanatory.

Thank you.

Two tables.xlsx