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

Using DORM 404 as an example and "helper" columns

in I10

=IFERROR(INDEX('404'!$A$3:$A$22,SMALL(IF($D$10='404'!$AG$3:$AG$22,ROW('404'!$AG$3:$AG$22)-ROW($A$3)+1,""),COLUMNS($A:A))),"")

enter with Ctrl+Shift+Enter

Copy across columns which will give list of cells which match maximum.

You will then need to concatenate these cells in E10 either with formula or VBA.

A similar method for G.

You can "hide" the helper columns anywhere on you sheet.

I copied the formula as is into I10 and copied it over 5 more spaces, but there is nothing showing up in those boxes. I did do the ctrl+shift+enter and it put the { } around the formula as well. was there something else I was suppose to do to make the rooms show up there.

See attached:

=IFERROR(INDEX('404'!$A$3:$A$22,SMALL(IF($D$10='404'!$AG$3:$AG$22,ROW('404'!$AG$3:$AG$22)-ROW($A$3)+1,""),COLUMNS($A:A))),"")

"404" references need to be changed accordingly

It didn't even show anything even in cell I10 where I put the formula

As you can see it works in the attached so what is different?

, ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

I did hit ctrl+shift+enter and it did add the { } to the formula. I tried to open the attachment you had but it gave me an error which I have attached.

and here is the formula with the array confirmed { } and nothing in the cell. I didn't change anything else on it.

Attached is xlsm as the file (old format) contains macros.

Thanks JohnTopley. I don't know why the same formula isn't working in the original worksheet but I used yours and added the concatenate formula to combine them in one and it worked great. Thanks again. Saved me a lot of headache.