Making a hyperlink from a formula

You can hyperlink almost anywhere

Add this into a cell, its what i generally do

=HYPERLINK("#"&CELL("address",Sheet2!A1))

Now the cell will read - #[Book1]Sheet2!$A$1 this is expected