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
Bookmarks