# How to Use INDEX MATCH MATCH in Excel (With Example)

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.