Help with Array Function: Avoid repeating values on MATCH/INDEX

I've gone through a couple similar posts but, have trouble applying the concepts to my case which is attached to this post.

I have a large table that I applied a match/index to extract the top ten rows. The formula for my top ten is as follows (found in cell AB174):

=INDEX($M$174:$M$447,MATCH(AE174,$X$174:$X$447, 0))

As you can imagine, when I have repeating values in the X column, the function reads only the first matching value in the M column. I need to compensate for repetition. This is where I know an array function will come into play.

I pulled another array function from a similar thread that I think correlates with my problem but, I cannot successfully apply it to my case. It originally reads as follows:

=IFERROR(INDEX($B$2:$M$45,SMALL(IF($A$2:$A$45=$O$2,ROW($A$2:$A$45)-ROW($A$2)+1),ROWS(A$1:A1)),MATCH($O$4,$B$1:$M$1,0)),"")

Please helpme apply an array to avoid repetition!

This worked. Thanks.

Unfortunately, I just found out the program I'm using in conjunction with excel can not interpret array functions. is there any other way to avoid repeating values without array functions?

Right, no CSE entry on AB174.

A pure copy/paste of the formula you supplied yeilds a "#N/A" readout. I'll see if I can troubleshoot the issue.

Seems like I'm getting the entire formula. I've also attached my spreadsheet again with your value in AB174.

=INDEX($M$174:$M$447,MATCH(AE174,INDEX($X$174:$X$447+ROW($X$174:$X$447)/10^6,,),0))

Yes, but this will cause me to use the CSE function for column AE you specified earlier. I need to avoid CSE entirely. Sorry if I wasn't clear before.