I'm trying to automatically create a hyperlink to a specific cell using the Hyperlink function.
=HYPERLINK("#'AM 5819 0001'!D10",
The first line is the cell reference, the second is just specifying what to display based on whether theres a value in the cell D13.
This formula works, but the cell references the cell D10. I want it to instead link to the D13 cell used in the second part of the equation.
I can use the equation below to call the specific cell i need based on the current cell,
=CELL("address",INDIRECT(ADDRESS(ROW(),COLUMN()-25)))
Is it possible to combine these two? I have tried but it returns an error. Code as below.
=HYPERLINK("#'AM 5819 0001'!CELL("address", INDIRECT(ADDRESS(ROW(),COLUMN()-25)))",
)
Thank you in advance!
=HYPERLINK("#'AM 5819 0001'!D10",
IF(D13<>"",CONCATENATE($AA$2,D13),"")
)
)
The first line is the cell reference, the second is just specifying what to display based on whether theres a value in the cell D13.
This formula works, but the cell references the cell D10. I want it to instead link to the D13 cell used in the second part of the equation.
I can use the equation below to call the specific cell i need based on the current cell,
=CELL("address",INDIRECT(ADDRESS(ROW(),COLUMN()-25)))
Is it possible to combine these two? I have tried but it returns an error. Code as below.
=HYPERLINK("#'AM 5819 0001'!CELL("address", INDIRECT(ADDRESS(ROW(),COLUMN()-25)))",
IF(D13<>"",CONCATENATE($AA$2,D13),"")
)
Thank you in advance!