HYPERLINK
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.
Lookup & ReferenceLookup & Matching Essentials
What it does
Creates a clickable link to a file or URL.
Syntax
HYPERLINK(link_location, [friendly_name])
Arguments
link_location(text) — The path or URL.friendly_name(text) — Display text.
Examples
Create Link
Link to Google.
FORMULA
=HYPERLINK("https://www.google.com", "Google")RESULT
Google
SAMPLE DATA
| A | |
|---|---|
| 1 | Link |
| 2 | (Clickable) |