Two-way Lookup

 

This example teaches you how to lookup a value in a two-dimensional range. We use the MATCH and INDEX function.

Below you can find the sales of different ice cream flavors in each month.

1. To find the position of Feb in the range A2:A13, use the MATCH function. The result is 2.

Match Function

2. To find the position of Chocolate in the range B1:D1, use the MATCH function. The result is 1.

Match Function

3. Use these results and the INDEX function to find the sales of Chocolate in February.

Index Function

Explanation: 217 found at the intersection of row 2 and column 1 in the range B2:D13.

4. Put it all together.

Two-way Lookup in Excel