Lookup w/ multiple matches & concatenate

[edokhotnik]

I have data as shown in a Before and After. I need to return multiple matches and concatenate them. Thank you for your assistance. Ed

Excel Workbook
	A	B	C	D	E	F	G
1	Before
2	Task	TaskID	Permit	Closed		TaskID	Requirements
3	Research	A-123	Yes	Yes		A-123	BCD
4	Develop	A-234	No	Yes		A-123	DEF
5	Test	A-345	Yes	Yes		A-234	GHI
6	Certify	A-456	No	No		A-234	BCD
7						A-234	RTY
8						A-345	XYZ
9						A-456	ABC
10						A-456	IJK
Sheet1

Excel Workbook
	A	B
14	After
15	TaskID
16	A-123	BCD - DEF
17	A-234	GHI - BCD - RTY
18	A-345	XYZ
19	A-456	ABC - IJK
Excel 2010 Sheet1

Excel 2010

 

[edokhotnik]

All,

I did some more searching on this topic and found this post to be very helpful. Thanks, Ed

http://www.mrexcel.com/forum/showthread.php?t=535854