How to use Two-way Lookup in Ms Excel

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 row number of Feb, use the MATCH function.

2. To find the column number of Chocolate, use the MATCH function.

3. To find the sales of Chocolate in February, use the INDEX function.

4. Put it all together.