1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Two Way Lookup Using VLOOKUP Part 1

By

1 of 6

Find Data at the Intersection Point of a Row and Column
Excel Two Way Lookup Using VLOOKUP

Excel Two Way Lookup Using VLOOKUP

© Ted French

Excel Two Way Lookup Formula Overview

By combining Excel's VLOOKUP function with the MATCH function, we can create what is known as a two-way or two-dimensional lookup formula that allows you to easily cross reference two fields of information in a database or table of data.

A two way lookup formula is useful when you want to find or compare results for a variety of different situations.

In the example shown in the image above, the lookup formula makes it easy to retrieve the sales figures for different cookies in different months simply by changing the cookie name and the month in the correct cells.

Excel Two Way Lookup Step by Step Tutorial

This tutorial is broken down into two parts. Following the steps listed in each part creates the two way lookup formula seen in the image above.

The tutorial involves nesting the MATCH function inside of VLOOKUP.

Nesting a function involves entering a second function as one of the arguments for the first function.

In this tutorial, the MATCH function will be entered as the column index number argument for VLOOKUP.

Tutorial Contents

Part 1

©2014 About.com. All rights reserved.