We have a two dimensional table with unique axis.

This example is simplified from real case. The user wants to know the value by entering values from both the axis. Like pr1 and south should return the value 2.

We need two formulas for this case, MATCH and INDEX. Both the formulas are relatively simple.

In the list f is the fourth letter.

INDEX forms coordinates for the range.

Range(B3:D5) forms an array. B3 is a corner where you start counting row and columns. First row and third column is D3 and value 6. Second row and first column is B4, the value 2.

Entering values are in fields G2 and G3. The pr3 is searched in B4:B6 with MARCH, and west in C3:E3, also with MATCH. Then INDEX is using the values form MATCH functions to find out the value for pr3/west which equals to 9.

Both INDEX and MATCH are embedded in G8.