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