Creating a Variable Hyperlink in Excel

This is cool!

The problem: 11 worksheets and hundreds of codes
Objective: the ability to type a code and be taken directly to that code wherever it is in the workbook.

It’s like the Find/Select feature in Excel, the user wanted to stay in the worksheet and minimize use of the ribbon.

One thing to know about creating hyperlinks.
Regular references to cells can look like: Sheet3!B5
But hyperlinks need to include a ‘#.” Therefore:


This video shows how to make the dynamic hyperlink. It’s crazy! We have to use COUNTIF, MATCH, OFFSET, INDIRECT, HYPERLINK and helper columns.

Download the workbook here:
This video was recorded at Casa de Montecristo by Cigar Inn at 2nd & 54th in New York City.

Contact me:


My book: Guerrilla Data Analysis 2nd Edition
My old blog: