I want to go to a cell (on the same sheet) using HYPERLINK but I won't have the column letter and row number but I will have the column number and row number.
Can those be used in the HYPERLINK function or do I have to convert them?
I found this:
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")
but it's a bit cumbersome. Is there a more elegant way of doing it in the context of the HYPERLINK function? Please note that I don't have numbers for the column and row but I'll be calculating them from formulas that i'll need to insert into the function.Thanks!
Can those be used in the HYPERLINK function or do I have to convert them?
I found this:
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")
but it's a bit cumbersome. Is there a more elegant way of doing it in the context of the HYPERLINK function? Please note that I don't have numbers for the column and row but I'll be calculating them from formulas that i'll need to insert into the function.Thanks!