• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

http://spreadsheets.about.com/od/lookupfunction1/ss/2012-06-01-excel-two-way-lookup-vlookup-part-1.htm

was emailed to:

Thanks for sharing About.com with others!

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

# Excel Two Way Lookup Using VLOOKUP Part 1

#### 1 of 6

Find Data at the Intersection Point of a Row and Column

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.

### Part 1

##### Excel Array Formulas

Ted French
About.com Spreadsheets

See More About
Explore Spreadsheets
See More About:
By Category
1. About.com
2. Technology
3. Spreadsheets
4. Excel Functions
5. Lookup Functions
6. Excel Two Way Lookup Formula Using VLOOKUP