1. Computing
Ted French

Excel VLOOKUP Array Formula Tutorial

By February 26, 2012

Follow me on:

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 one of Excel's most used functions. Its purpose is to make it easy for you to locate specific in a
Comments
March 27, 2012 at 6:26 pm
(1) washable kitchen rugs says:

Very useful. I’ve saved the information and I’ll be coming back to learn more.

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.