Issue with formula array

Hello i have this formula hyperlink:
=HYPERLINK("#"&"'map'!"&ADDRESS(SUMPRODUCT(('map'!A1:Z999=O4)*ROW(A1:Z999));SUMPRODUCT(('map'!A1:Z999=O4)*COLUMN(A1:Z999)));" "&O4)
but every time i copied it down, it change array acordingly, for example:
=HYPERLINK("#"&"'map'!"&ADDRESS(SUMPRODUCT(('map'!A1:Z999=O4)*ROW(A1:Z999));SUMPRODUCT(('map'!A1:Z999=O4)*COLUMN(A1:Z999)));" "&O4)
=HYPERLINK("#"&"'map'!"&ADDRESS(SUMPRODUCT(('map'!A2:Z1000=O5)*ROW(A2:Z1000));SUMPRODUCT(('map'!A2:Z1000=O5)*COLUMN(A2:Z1000)));" "&O5)
=HYPERLINK("#"&"'map'!"&ADDRESS(SUMPRODUCT(('map'!A3:Z1001=O6)*ROW(A3:Z1001));SUMPRODUCT(('map'!A3:Z1001=O6)*COLUMN(A3:Z1001)));" "&O6)
is it possible to make this formula that the bolded section never changes?

Put $ in front of every range to lock it. Or select cell and press F4 it will lock all ranges in that cell.

$A$1:$Z$999 - will lock this range. You can copy, it will stay the same.

Thanks, it solved a problem.
I have one additional question, is it possible to make this formula to show blank cell or something like that, but not the #VALUE! when it does not find value

=IFERROR(HYPERLINK("#"&"'map'!"&ADDRESS(SUMPRODUCT(('map'!A1:Z999=O4)*ROW(A1:Z999));SUMPRODUCT(('map'!A1:Z999=O4)*COLUMN(A1:Z999)));" "&O4)), "")

As Glenn above mentioned.

I try this
=IFERROR(HYPERLINK("#"&"'References'!"&ADDRESS(SUMPRODUCT((References!$A$1:$A$999=AY13)*ROW($A$1:$A$999));SUMPRODUCT((References!$A$1:$A$999=AY13)*COLUMN($A$1:$A$999)));" "&AY13)), "")
but it shows error, that "You've entered too few arguments for this function"

Used your file. It works perefectly. Thanks