Simple Hyperlink function using an indirect address

[mario92]

Hi,
I want to reference a cell with a formula that will take the link to the bottom of a sheet where the last row is filled in but also want it to be dynamic. I have the last row in a cell (with a dynamic formula) in which i want hyperlink to reference. Below is what i've been trying. Q1's cell has the formula that displays the last row (=ROW(OFFSET(A10,COUNTA(A$10:A$1048576)-1,0))). When Q1 updates i would like the hyperlink to update as well.
=HYPERLINK(INDIRECT(Q1), "bottom")

I've looked for some time and haven't found anything. I would think its a simple issue and any help would be greatly appreciated

 

[Fluff]

How about

=HYPERLINK("#A"&Q1,"Bottom")

 

[mario92]

sorry, i still get reference isnt valid
what does #A do?

 

[Fluff]

What is the value in Q1?

 

[mario92]

Again the formula is this
(=ROW(OFFSET(A10,COUNTA(A$10:A$1048576)-1,0)))

the actual value in the cell is 769

 

[mario92]

sorry i mistyped
the value in Q1 is $A$769

 

[Fluff]

How do you get that value with the formula you have shown?

 

[mario92]

im really sorry, this is the formula.

=ADDRESS(MAX((A1:A10001<>"")*(ROW(A1:A10001))),COLUMN(A1:A10001))

 

[mario92]

i got it now, i just removed the A.

=HYPERLINK("#"&Q1, "Bottom")

this works. Sorry to waste your time

 

[Fluff]

Glad you sorted it & thanks for the feedback.