Need Macro or Vlookup for 2 excel sheets

[csteps]

I need column M (Sheet:Procore) to get the email addresses from column D (Sheet: Contacts)
Some companies will have multiple emails that need to be combined like my example for 'Box Company' , with a comma
Let me know if you have any other questions, thanks!

 

[kweaver]

How about:

Book6
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Company												EMAIL(s)
2	Apex Co.												ryan@apex.com
3	Box Co.												srees@box.com, sferrel@box.com
4	Cat Co.												pere@cat.com
Procore

Cell Formulas
Range	Formula
M2:M4	M2	=TEXTJOIN(", ",TRUE,FILTER(Contacts!$D:$D,A2=Contacts!$C:$C,""))