Return Multiple matches

[A_SIRAT]

Good day,

Please assist me with a formula that could return multiple matches for a given value. I have noted that The FILTER function gives me this results but I am not using Office 365.

1. The DATA ENTRY SECTION has all the information.

2. The report summary is Order specific. If I ENTER the order nr. in cell L2, it should populate all the cells from M6 with the matching values for order nr. 1. 

Thanks for assistance.

[#2 · Accepted solution]

@A_SIRAT 

If without dynamic arrays, in M6

=IFERROR(INDEX(E$3:E$21,
  AGGREGATE(15,6,1/($D$3:$D$21=$L$2)*(ROW($D$3:$D$21)-ROW($D$2)),ROW()-ROW(M$5))),
"")

drag it to the right till end of the range and after that entire M6:P6 down till empty cells appear.

[#3]

Thank you Sergei for your quick fix.. ! appreciated.

[#4]

@A_SIRAT , you are welcome