Concatenate values that meet lookup criteria of Products and names.

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,