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.
VLOOKUP can also be used in an array formula which makes it possible to return multiple fields of data or even entire records from a database.
This tutorial list includes step by step examples of how to use VLOOKUP to return single fields of data or multiple fields using an array.
Excel VLOOKUP Step by Step Tutorial
Excel VLOOKUP Function
This tutorial covers how to setup and use the VLOOKUP function in Excel to retrieve data from a database. The tutorial includes a step by step example of how to use VLOOKUP in Excel.
Excel VLOOKUP Array Formula Tutorial
Excel VLOOKUP Function
This tutorial covers how to setup and use the VLOOKUP function in an array formula to retrieve multiple fields of data from a database. The tutorial includes a step by step example of how to use Excel 's VLOOKUP in an array formula.
Text version - Excel VLOOKUP Tutorial
Excel VLOOKUP Function
This tutorial covers how to setup and use the VLOOKUP function in Excel to retrieve data from a database. This text only tutorial is intended for experience Excel users.
Excel VLOOKUP Array Formula Tutorial Data
Excel VLOOKUP Function
This article gives instructions for copying the sample data for the Excel VLOOKUP Array Formula Tutorial.
