What it does: The Hyperlink() function links the cell to a local location (another point in the spreadsheet, another tab, specific cell, etc..) or to an actual URL like Google.com.
Plain English: This function can be used to link to a very specific points in OTHER workbooks, the workbook you’re currently in, or most commonly to a live URL.
Arguments: HYPERLINK(link,[name])
- Link – The link you want to visit (local or world wide web URL)
- Name – Optional – How you want the link to appear in the cell. Example: Google