Create Dynamic Hyperlinks in Excel

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on April 29, 2023
Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to create dynamic hyperlinks in Excel Sheet.

dynamic hyperlinks Main Function

Dynamic Hyperlink using HYPERLINK Function

Dynamic hyperlinks are hyperlinks that change based on cell values.

In the example below, we will create a dynamic hyperlink to a cell based on the result of a MATCH Function.


Here we lookup “James” in sheet ‘Data’ and link to corresponding row. Let’s break the function up into two parts to make it easier to follow:


The HYPERLINK Function allows you to create a link to a location point in the same workbook, different workbook, or an external URL. Its syntax is:

HYPERLINK function

The following example will dynamically link to cell B8 in the worksheet ‘Data‘.

=HYPERLINK("#"&"Data!B"&C3,"Click Here")


In the above example, the ‘Row #‘ column provides the row number for the ‘link_location‘ argument. It has been calculated using the MATCH Function like this:



Note: To get the required row number, the number of rows above the selected range (2) has been added.

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List