Excel VLOOKUP Array Overview
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.
Normally the function is used to return information from one cell in a database. VLOOKUP's usefulness can be extended, however, by using it in an array formula which allows you to find multiple fields of information with one VLOOKUP function.
This step by step tutorial walks you through creating and retrieving data with a VLOOKUP array formula.
