Row function alternative

Hello,

We have a requirement to find multiple rows for a given value. I was able to achieve this using this array formula :

[ =IF(ROWS(A$15:A15)<=$I$2,INDEX(A$2:A$7,SMALL(IF($A$2:$A$7=$I$1,ROW($D$2:$D$7)-ROW($D$2)+1),ROWS(A$15:A15))),"") ].

But we are using dashboards and it doesn't support the ROW/S function. Searching it's alternatives from what I understood it's best to use INDEX/MATCH function. I am not very proficient with Excel so if this formula can be re-written with index/match or any other function without rows .

This is the requirement : Lookup is the value which is match against the records on the table to left and results are show in the result rows . Now I want to achieve this without using the ROW/S function.

Thanks

Lookup Mickey
Count 3

Name Class Roll Marks

Mickey 5 13 60
Anil 7 14 70
Sumit 5 90 80
Mickey 8 27 99
Mickey 9 88 8
Anil 9 78 9

Result Rows

Name Class Roll Marks
Mickey 5 13 60
Mickey 8 27 99
Mickey 9 88 8