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

Match Function

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

Match Function

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

Index Function

4. Put it all together.

Two-way Lookup Result