Excel's VLOOKUP Function

By Ted French, About.com Guide

Overview of Excel VLOOKUP Function

Related Tutorial: Text only version - Excel 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

Previous

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

Next