Google Sheets: Lookup and Merge Data Based on Multiple Criteria

Dear All,

I have data with criteria and dates. Based on multiple criteria data should be pulled up and merged (if multiple criteria matched). Attached the manually mocked up data with the expected output. Please do the needful. Thanks in advance.

For Excel 2016 or lower without Textjoin function
Helper columns are required

AJ2:BN2
=AI2&IF(ISNUMBER(SEARCH(" "&B2&",",$AH$2&"")),TEXT(B$1,", mmm d"),"")

AG2
=MID(BN2,3,99)

for Excel 2019 or above
=TEXTJOIN(", ",,REPT(TEXT($B$1:$AF$1,"mmm d"),ISNUMBER(SEARCH(" "&B2:AF2&",",$AH$2&""))))

or UDF
=JoinH($B$1:$AF$1,B2:AF2,$AH$2)

Please Login or Register  to view this content.

Hi Bo_Ry,

Thanks for your valuable time and effort on this. I have to append this into the google sheet. Sorry for not explained this before.

For Google Sheet

=INDEX(TEXTJOIN(", ",1,REPT(TEXT($B$1:$AF$1,"mmm d"),ISNUMBER(SEARCH(" "&B2:AF2&",",$AH$2&"")))))