Excel VLOOKUP Array Formula Tutorial

Normally VLOOKUP is used to retrieve a single field of information from a database or list.

The usefulness of VLOOKUP can be extended, however, by using it in an array formula. Doing so allows you to retrieve multiple fields of data or even entire records from a database.

For details on how to setup and use VLOOKUP in an array formula read the step by step Excel VLOOKUP Array Formula Tutorial

Related Tutorials

• Excel VLOOKUP Step by Step Tutorial
• Lookup Formula with Multiple Criteria in Excel
• Excel HLOOKUP Function

one of Excel's most used functions. Its purpose is to make it easy for you to locate specific in a