In Excel ONLINE I want to create a dynamic hyperlink to a cell in the same sheet.
With this formula I get the cell reference:
=ADDRESS(ROW(B2);MATCH(G4;B2:G2;0)+COLUMN(B2)-1)
But how to create a link to that cell?
Is it possible at all?
In Excel ONLINE I want to create a dynamic hyperlink to a cell in the same sheet.
With this formula I get the cell reference:
=ADDRESS(ROW(B2);MATCH(G4;B2:G2;0)+COLUMN(B2)-1)
But how to create a link to that cell?
Is it possible at all?