Thanks.. getting few items to check out for dynamic ranges etc.
Have others that were looking for answer such as this hyperlink, do you
think my example is complete, or any extraneous items.. or did I accidently
get it right :)?

=HYPERLINK("#"&CELL("address",OFFSET(A505,$Z$1,1)) ,"P2") for downwards
=HYPERLINK("#"&CELL("address",OFFSET(A505,-1,1)),"P2") for up

for:
=HYPERLINK("#"&CELL("address",