Excel VLOOKUP Step by Step Tutorial

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

• Excel VLOOKUP Function Tutorial
• 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