1. Computing
Ted French

Find Multiple Fields of Data with Excel VLOOKUP

By November 28, 2012

Follow me on:

VLOOKUP is one of Excel's most used functions.

It is limited, however, to returning a single field of data from a data table.

We can get around this limitation by combining it with the COLUMN function to create a lookup formula that will return multiple fields or entire records if desired.

So instead of finding only the price of an item, you can also find the part number, the supplier, and any other information with one formula.

To find out more read the step by step tutorial on Find Multiple Fields of Data with Excel VLOOKUP.

Related Tutorials

Comments
October 17, 2013 at 7:28 am
(1) nilesh says:

i have followed all steps on “Find Multiple Fields of Data with Excel VLOOKUP”, but on page 7 of 10 “Nesting the COLUMN Function” i have doubt to clarify. why we have taken “B1″.
and i m using this formula between 2 worksheet but receiving error of # N/A.

kindly help me out.

can any expert help on this.

Leave a Comment

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

©2014 About.com. All rights reserved.