Vlookup or similar to return an array

[DanD]

Afternoon All,

What I'd like to achieve is to use something similar to a vlookup but return multiple results

I have one sheet that contains data about products, the product number, the class it belongs to, and many other bits. The data is sorted by product number.

In a second sheet I have a list of classes in column G, I'd like to return a list of product numbers in columns H to wherever is needed.

For example there might be two products in class one, class one is in G1, with the first product number in H1 and the second in H2.

Any tips?

Thanks in advance

Dan

 

[DanD]

I suppose it could, but I'm having difficulty getting it give me a list of Product Numbers By Class, It always wants to summarise the dat somehow.

I've never really used Pivot tables....

 

[jeffreybrown]

Dan,

Maybe if we saw a small set of your data that could help. Pivot tables are very easily and once your learn it will help you consolidate your data.

http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

Maybe this could help...

http://www.cpearson.com/excel/pivots.htm