Excel Two-Way Lookup Example

by

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

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

Worked Example:   Subtract Numbers in Excel

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

Worked Example:   How to calculate percent change in Excel

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

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

Worked Example:   Paste Special Operations in Excel

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

4. Put it all together.

Leave a Reply

Your email address will not be published. Required fields are marked *