Forum Discussion
jbbarnabas
Oct 01, 2020Copper Contributor
Multiple matches in workbook
Good day community Need assistance please. I require a formula which provides me with all the relevant matched/dupplicated data and not only the first match found. When comparing sheet 1 with s...
HansVogelaar
Oct 02, 2020MVP
In D2 on Sheet 1, as an array formula confirmed with Ctrl+Shift+Enter:
=TEXTJOIN(",",TRUE,IF(('Sheet 2'!$A$2:$A$200=A2)*('Sheet 2'!$B$2:$B$200=B2)*('Sheet 2'!$C$2:$C$200=C2),ROW('Sheet 2'!$A$2:$A$200),""))
Change Sheet 2 to the actual name of the second sheet, and adjust the ranges if Sheet 2 has more than 200 rows of data.
Then fill down.