you could use HYPERLINK to construct a clickable hyperlink with a formula.
you might also use HYPERLINK to create email links.
HYPERLINK Function
The Excel HYPERLINK function returns a hyperlink to a given destination. You can use HYPERLINK to create a clickable hyperlink with a formula. The HYPERLINK function can build links to workbook locations, pages on the internet, or files on network servers.
