Concatenate if 3 criterias match

[Kinjal Doshi]

Hi,

It's with reference to below link, it works great with 2 columns, but I have a third column 'firm'(based on the example shown in spreadsheet in below given link)... I want it to concatenate project list if partner name and firm matches

Can someone please help??


https://excelforum.com/excel-formulas-and-functions/1086301-concatenate-multiple-vlookup-index-match-results-with-commas.html

[Kinjal Doshi]

Hi,

It's with reference to below link, it works great with 2 columns, but I have a third column 'firm'(based on the example shown in spreadsheet in below given link)... I want it to concatenate project list if partner name and firm matches

Can someone please help??


https://excelforum.com/excel-formulas-and-functions/1086301-concatenate-multiple-vlookup-index-match-results-with-commas.html

Also attaching a sample book... Please help asap