How To Retrieve Multiple Results In One Cell

[alethea2022]

I need to get all email addresses for one company out of a list of data which looks like this

Is there anyway to see if the company is ABC Limited bring back all emails you find in one cell, this sounds a bit far fetched! any help appreciated, I have a bit list and need to consolidate the companies so the company only appears once with all the email addresses in one cell next to it or at least ABC Limited in column 1 ali@abc.com in column 2 ali@abc.com in column3 I don't know if a HLookup would do this, i have never used Thank you so much Ali

ALI@ABC.COM	ABC LIMITED
BOB@ABC.COM	ABC LIMITED

 

[Jeffrey Mahoney]

Please try this
=TEXTJOIN(";",TRUE,FILTER(A12:A14,B12:B14="ABC LIMITED",""))
Where A12:A14 is you list of emails and B12:B14 is the list of company names

 

[alethea2022]

Oh My goodness, that is the craziest cool formula, that you so so much