I had this formula working correctly in Excel, but when I'm trying to do the same in Google Sheets, it's not having it:

=TEXTJOIN(", ",1,FILTER(People2,ISNUMBER(SEARCH(People2,D2)),""))

I have used Exceljet, precisely as described here:

Using Arrayformula

Note: for a simplified example checkout this