Concatenate Column A if X is Column B and Y is in Column C

[dmcgetti]

I have a list of invoice numbers in column A, customer names in column B, and part numbers in column C.

I need to combine invoice nummbers to one cell depending on part number for each customer.

123	SHOP ABC	PART X
456	SHOP ABC	PART X
789	SHOP XYZ	PART X
987	SHOP ABC	PART Y
654	SHOP ABC	PART W
321	SHOP XYZ	PART Y

<tbody>
</tbody>

So if I am Looking for Shop ABC's invoices for Part X the cell would read "123 456"

Thanks as always!

 

[Roderick_E]

Easier to make a pivot table and filter by shop and part number

 

[dmcgetti]

Easier to make a pivot table and filter by shop and part number

I am ultimately using the spreadsheet for a mail merge...

 

[Aladin Akyurek]

In D1 control+shift+enter, not just enter, and copy down:

=TEXTJOIN(" ",TRUE,IF($B$1:$B$6=B1,IF($C$1:$C$6=C1,$A$1:$A$6,""),""))

Hope this is what you are looking for.

 

[FDibbins]

This works for 2 matches - will there be more?

	J​	K​	L​	M​
2​	123​	SHOP ABC	PART X	123 456
3​	456​	SHOP ABC	PART X
4​	789​	SHOP XYZ	PART X
5​	987​	SHOP ABC	PART Y
6​	654​	SHOP ABC	PART W
7​	321​	SHOP XYZ	PART Y	321 321

M2=IFERROR(J2&" "&INDEX($J3:$J$7,MATCH(K2&" "&L2,INDEX($K3:$K$7&" "&$L3:$L$7,0),0)),"")
copied down