HYPERLINK
Lookup

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet

Syntax:

=HYPERLINK(link_location, [friendly_name])

Example:

=HYPERLINK("http://www.example.com", "Click here")