You can use **INDEX MATCH** in Excel to look up a vertical value in a column and return a corresponding value in another column.

You can take this one step further by using **INDEX MATCH MATCH** to look up both a horizontal value and vertical value and return the corresponding cell in a matrix.

You can use the following basic syntax to do so:

=INDEX(A1:E7, MATCH(B9, A1:A7,0), MATCH(B10, A1:E1,0))

This particular formula looks up the value in cell **B9 **in the vertical range **A1:A7**, then looks up the value in cell **B10 **in the horizontal range **A1:E1** and returns the corresponding cell value where these two lookup values intersect in the overall range of **A1:E7**.

The following example shows how to use this syntax in practice.

**Example: How to Use INDEX MATCH MATCH in Excel**

Suppose we have the following dataset in Excel that shows the sales made at various retail stores for some company during each quarter:

Suppose we would like to look up the sales value for the **West** region during **Quarter 3**.

We can type the following formula into cell **B11** to extract this value:

=INDEX(A1:E7, MATCH(B9, A1:A7,0), MATCH(B10, A1:E1,0))

The following screenshot shows how to use this formula in practice:

The formula returns a value of **37**, which corresponds to the sales value for the **West** region during **Quarter 3**.

If we change the values for the region and quarter, the formula will update the sales value accordingly.

For example, suppose we change the region to **Pacific** and the quarter to **Quarter 4**:

The formula returns a value of **34**, which corresponds to the sales value for the **Pacific** region during **Quarter 4**.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

Excel: How to Use VLOOKUP to Compare Two Lists

Excel: Use VLOOKUP to Return Multiple Values Horizontally

Excel: How to Use VLOOKUP by Date