Return all Product Names listed against a single Account

I have a list of all sold deals by specific Account IDs, which lists multiple products by name.

In a separate summary sheet I have a listing of Accounts (and IDs), for which I am trying to return all the different product type names into one cell entry, for that particular account

There are over 80 accounts in 1 report, and 250+ deals in the other sheet.

How can I lookup the Account ID in the sold deals sheet, and return all the different product name entries.

Thanks in advance
Regards
Rohan

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I don't see any attempted formulae in your attachment or expected outcomes. The latter are essential, please, and the former helpful to see.

Fine, but we MUST know what your expected outcomes are! Please add at least some of these to your sample file.

I'm sorry, Rohan, but you are not giving the information I am asking for! In those red columns, I want to see your expected outcomes - exactly as they should appear, not as vague statements. You have not even indicated where in the source sheet you expect the information to be found. In addition, I don't think that your sample data is extensive enough: the information in your first red column suggests that there will be multiple rows per customer in the source data, but your sample data doesn't show this.

I know it is obvious to YOU what you want, but I'm not clairvoyant and I need a bit more specific information, please.

OK, so it seems to me that a lot of these columns can be organised using this type of function:

=IF(COUNTIF(lookup_array,value)>0,value_if_true,value_if_false)

But again, you haven't given expected outcomes. Type in the red columns the results you expect on each of those rows.

OK - come back to it tomorrow when you're fresh. When you do, please attach a copy of the file with the detail I've requested, and then, hopefully, you'll get a solution.