Hi Guys
I am looking for a way to return multiple items under a product.
for example, if I do a vlookup on product to return the items associated with that product the formula only brings back the first match and not the rest of the items.
Please see attached.
On the attached sheet you will find two tables. On the left-hand (sheet 1), is the result I want to be displayed after manually entering it. Sheet 2 is the the DB to do the lookup from.
This is a small example of the data I am working and wondering is there an automated way I can do this?.
Many thanks for your support in advance
MH Hersi
Bookmarks