formula to return multiple values in single cell not working

Excel 2013, 6 tabs in the worksheet. The total tab and the 5 data tabs. I am having an issue with the formulas that is on the total tab. I need it to look up information on the data tab and return the result of a room/wing #. My issue is that it is only returning the first listing that it comes to and doesn't list any additional rooms/wings that may have the same score. The formulas all work except for that. I've tried Vlookups, index-match, and something with VBAs and nothing is working.

The formula I'm needing worked on is on the totals tab E7-E11 and G7-G11. If I haven't made it clear of what I'm wanting please let me know, and thanks ahead of time.

If it's locked the code is 123