Concatenate Based on the Criteria

[nawas]

Dear All,

Appreciate your urgent support to build a concatenate formula. Attached the sample worksheet with desired result in last column.

If Cell H2 matches with D:D range then merge corresponding Cell values in E:E in one cell.

I was trying to put concatenate formula one by one cells, but its quite hectic to identify each range manually.

Hope the attached spreadsheet will give better understanding for my desired result.


Thanks a lot