Thread: Is it possible to perform multiple vlookups (index/matches)?

Sorry that the title-post is a bit vague, but I can't think of any other ways to describe the problem at hand. Is this possible? I am working with two columns within a large database. In one column, I have customer account numbers. In the other, the product in which they are enlisted. Almost every account number is repeated somewhere within the list, with a different product each time. I have tried sorting by account number and concatenating the associated products into one cell, but there is no way to stop the concatenation upon a change from one account number to the next. I have also tried a variety of manipulations among the vlookup, index/match, small, and row(s) functions, yet nothing seems to work. I need a way I can display all of the products listed under each account number- not necessarily in the same cell, but horizontal indeed. Would a pivot table be of any help? Any assistance would be greatly appreciated.

Thanks!

Hi

surely this can be done with the help of PIVOT. (if you can attach the excel sheet will let you know)
Regards
Shridhar

If you all you want to do is concatenate the products list for each customer into one cell, then do this. Sort by customer name and apply this formula:
=IF(A1=A2,C1&", "&B2,B2)
This formula was created with customer number in column A and product name in column B with headers in the first row. It will separate each product with a comma and a space. It will start the concatenation over again once it reaches a new customer ID.