Return multiple values horizontally.

Hello to all -

I managed to found an array formula that helps to return multiple values with a condition. Below the formula:

Formula:

{=IFERROR(INDEX($J$4:$J$8, SMALL(IF($N4=$H$4:$H$8, ROW($H$4:$H$8)-MIN(ROW($H$4:$H$8))+1, ""), COLUMN(A$1))),"")}

I am attaching a simple file. In cell O4 I paste the formula, and I drag it as much as I need. But my issue comes when the formula begins the calculations. I need to calculate 50 columns with over 9,000 rows each column (over 45,000 arrays). Imagine the processing load to my computer and the consuming of time.

I want your help if there is a simpler formula to work with that allow me to obtain the same result.

I prefer formula instead of VBA. I know VBA Codes are of great help, but I can not record VBA codes in my computer because of Office Security Settings.

I will appreciate any help that you can give me.

Best regards to all and please have a great day.

Samuel Cruz.
Matamoros, Mexico.