How to use Two-way Lookup in Excel

Nov 06, 2020 • edited Nov 07, 2020

How to use Two-way Lookup in Excel

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.

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

#Tutorial#How To#Functions#Lookup & Reference

How to use Today's Date in Excel

How to use Vlookup function in Excel