Match Multiple ID's to Account Numbers List in New Columns

[brandonmcg]

I have a list that has two columns. The first column is an account number. The second column is a customer identifier or tax ID.

A customers Tax ID in column B can have five or more account numbers in Column A

Is there a way to match all of the associated account numbers?
B2 matches B3 and B5.
List the other account numbers in columns right of B. There can be as many as 20 account number matches per ID.
Making sense?

Account Number	ID	Match 1	Match 2
123	111	789	852
123	111	789	852
789	111	123	852
456	222
852	111	123	789

 

[Eric W]

Try:

Book1
	A	B	C	D	E
1	Account Number	ID	Match 1	Match 2	Match 3
2	123	111	789	852
3	123	111	789	852
4	789	111	123	852
5	456	222
6	852	111	123	789
7
8
9
10
Sheet4

Cell Formulas
Range	Formula
C2:E10	C2	=IFERROR(AGGREGATE(15,6,$A$2:$A$10/($A$2:$A$10<>$A2)/($B$2:$B$10=$B2)/(MATCH($A$2:$A$10&"|"&$B$2:$B$10,$A$2:$A$10&"|"&$B$2:$B$10,0)=ROW($A$2:$A$10)-ROW($A$2)+1),COLUMNS($C2:C2)),"")

 

[brandonmcg]

I appreciate your help. Saved me many hours. Thank you again.