Using an array formula I can find the row number of the last entry in a list regardless of entries {=MAX(IF($A$10:$A$2000<>"",ROW($A$10:$A$2000)))}. The number of entries in list is never the same. While I can find the row number and display the value, I can't click to get to it. . I want to be able to create a link or name to get to that row but cannot find a away to create a link or name based on a variable that changes.

I thought INDIRECT might work but links and names can't be set based on a variable fields or formula. I searched forum but can't find a similar issue resolved, so hoping someone can give me some hints / suggestions on what to try.

Thank you in advance for any help