Count if or Index Match with multiple Rows

Okay so I have a bit of a complicated formula - at least for me - that I'm working on. What I'm trying to do is compare locations and if two people have the same location I want the other person's name in column D.

So right now my formula looks like this:

=IF(C2>1,INDEX(B:B,MATCH(E2,E:E,0)),"")

Trouble is, that's only going to pull the first row that the index match finds. I need it to pull the missing name. So sometimes that means the first row the index match finds will be good, other times it should be the second row the index match finds, and still others it should be the third row that the index match finds.

I've updated it.

How about

Formula:

=TEXTJOIN(", ",,FILTER($B$2:$B$9,($E$2:$E$9=E2)*($B$2:$B$9<>B2),""))

Okay that totally works. I've never seen textjoin or filter before. I'll have to look into them.

Glad to help & thanks for the feedback.