Hi,
Required a formula help to as based on data situated at Column A to D, look up the values in two tables of Column F group and concatenate Products in table-1 column G4:G6 and Sum the quantities in Column H4:H6,
As well group and concatenate names in table-2 column G11:G18 as each number of lookup values in Column F and return the payment status and concatenate in H11:H18.
Sample sheet attached with expected results to the reference.
Thanks,
Bookmarks