Excel 2007 VLOOKUP Step by Step Tutorial

The Excel VLOOKUP Function

Excel 2007's VLOOKUP Function

© Ted French

Overview of Excel 2007 VLOOKUP Function

Related Article: Text only version - Excel 2007 VLOOKUP Function

Excel's VLOOKUP function, which stands for vertical lookup, can help you find specific information in large data tables such as an inventory list of parts or a large membership contact list.

Following the steps in the tutorial topics below walk you through using the VLOOKUP function to find specific information in a spreadsheet table.

Tutorial Topics

• Entering Tutorial Data


• Opening the VLOOKUP dialog box


• The Lookup Value


• The Table Array


• The Column Index Number


• The Range Lookup


• Using the VLOOKUP Function


• Excel VLOOKUP Error Messages

• The Excel VLOOKUP Function
• Entering the Tutorial Data
• The VLOOKUP Dialog Box
• The Lookup Value
• The Table Array
• The Column Index Number
• The Range Lookup
• Using the VLOOKUP Function
• Excel VLOOKUP Error Messages