Why am I getting the #NAME? error

[Victtor]

original formula in another worksheet (works properly):

=ARRAY_CONSTRAIN(ARRAYFORMULA(IF(I24="","",INDEX($P$4:$P$104,SMALL(IF($Q$4:$Q$104=L24,ROW($Q$4:$Q$104)-ROW($Q$4)+1),COUNTIF($L$24:L24,L24))))), 1, 1)

I copied and pasted into another worksheet (as soon as I did this, it gave me a #NAME? error) then I changed the cell references to the new sheet (still #NAME? error):

=ARRAY_CONSTRAIN(ARRAYFORMULA(IF(M5="","",INDEX($C$5:$C$157,SMALL(IF($K$5:$K$157=M5,ROW($K$5:$K$157)-ROW($K$5)+1),COUNTIF($K$5:K5,K5))))), 1, 1)

Please help. Could it be different versions of excel?

 

[MARK858]

That looks like a Google Sheets formula rather than an Excel formula.

 

[Norie]

Is this Excel or Google Sheets?