Lookup & Reference Function - HYPERLINK

Create clickable links for large sets of data using the new HYPERLINK function. This one only became available from Office 365, so it's hot off the press!

The video shows the HYPERLINK function in use.

The final written calculation is below:

=HYPERLINK(B3,C3)

In this formula, B3 contains the URL for the link and C3 contents the text we want to display.