Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

"CONSOLIDATION" WITH VLOOKUP

Posted by DAN on May 21, 2001 1:46 PM

IS IT POSSIBLE TO VLOOKUP SEVERAL ITEMS AND COMBINE THE RESULTS;

I LIKE TO DO SOMETHING LIKE THIS:

=VLOOKUP (“PEN RED” AND “PEN BLUE”, INVENTORY, QTY, 1)

I NEED TO DO THIS CONSOLIDATION FOR A LONG LIST OF DIFFERENT ITEMS.

ARE THERE ANY OTHER SUGGESTIONS?

THANKS,

MIAMI, FL.

Check out our Excel Resources

Re: "CONSOLIDATION" WITH VLOOKUP

Posted by Dave Hawley on May 21, 2001 8:39 PM

Hi Dan

You could use VBA for this, or put each VLOOKUP in a seperate cell then join them together in another, eg:
In A1
=VLOOKUP (“PEN RED”,INVENTORY, QTY, 1)
In A2
=VLOOKUP (“PEN BLUE”,INVENTORY, QTY, 1)
In A3
=VLOOKUP (“PEN GREEN”,INVENTORY, QTY, 1)
...Then in cell A4
=A1 & " " & A2 " " & A3

Have you looked at using a small Pivot Table ?

Dave
OzGrid Business Applications

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.