"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.

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