Returning multiple cells based on criteria of other cells

I have a student data sheet currently feeding subject summary tabs picking out key parts.

Currently, I have the following formulae to pick out names and their associated data from a list based on the value attached to those names in a given cell (Currently N6). See the separate English or Maths tabs attached.

=IFERROR(INDEX(Transition!$DY$1:$EK$207,SMALL(IF(Transition!$EK$1:$EK$207=$N$6,ROW(Transition!$EK$1:$EK$207)),ROW(2:2)),A$5),"")

I am trying to extend this to now return the names, AND the values, from two areas on the data sheet (English AND Maths) based on whether those values meet criteria specified in the summary sheet. So on the English & Maths tab, I have set in AL6 & AL7 boxes to specify values I wish to look between. Then I am trying to get the sheet to return ALL students for whom the data on the Transition sheet (Columns EK for English & BT for Maths) matches that criteria, together with the values associated for those students in EK & BT from the transition sheet.

Any suggestions much appreciated.

Not exactly certain what you were looking for....where exactly you wanted the results.
I assume you wanted to replace the existing ones, so maybe this is what you need.

It lists all students that fit the criteria in AL6:AL7 for BOTH English AND Math.
I removed the -1 from N6 since it isn't used now.

Massive, massive thanks! I can't tell you how long I had been trying to nail that for.

And while I had been aiming for the top one the second will be a very good fit for a slightly different project also, awesome! Thank you both.