Concatenate Sumproduct

[traggs25]

I have a sheet that ALMOST does exactly what I need. Basically in the sheets "SS", "Sci", "ELA", "Math" I have data about individual teachers with the rooms and periods they teach. I use the sheet "Scrap" to pull off all the information from those 4 sheets into one and retype the periods into individual days. Lastly, on the "Rooms" sheet I want to see which rooms are used during each period AND what teacher uses that room at that time.

https://docs.google.com/spreadsheets...it?usp=sharing

This is what I ended up with which works GREAT!!!
At the moment, what happens is if there is 1 match then it returns a name but >1 match returns a number.

Is there a way to add on to this formula in order to make it so that when there is >1 match it will concatenate the names together (maybe with "/" between the names).

(for example on the sheet "Rooms" instead of G24 saying "2" I'd want it to say "Jim/Sam". I want to be able to drag the formula across and down to the entire area. And it could have several names concatenated together)

Thank you very much for your help. This forum always seems to come through!
Traggs

[AliGW]

So this is a Google Sheets query - yes?

[traggs25]

Yes. Am I in trouble? LOL

Did i post in the wrong place?

[AliGW]

I've moved the thread to the correct section.