GET.LINK

GET.LINK — the target of the hyperlink attached to cell as a string

GET.LINK(cell)

cell: the referenced cell

The value return is not updated automatically when the link attached to cell changes but requires a recalculation.