Excel Hyperlink Drop-Down List - Navigate to Another Worksheet

Download the featured file here: www.bluepecantraining.com/cre...
In this video I demonstrate how to create a drop-down list that contains hyperlinks to other worksheets. This is great method for navigating worksheets.
------------------------

[@mcwolfsanalytics6279]

Thank you very much, Chester! Tried to use the Hyperlink function to navigate through multiple sheet, however it didn't work out. After watching your video, I could finally create a button that could navigate me through multiple sheets without any errors. Thank you!

[@IvanCortinas_ES]

Great tutorial. Thank you very much!!!

[@zorkminer]

This video is really great and a must save. Thank you for this!

[@mr.guerra5060]

Amazing!! thank you for the great step by step video!!

[@moelmakrani7116]

Great video and trick, Chester. Liked it! Cheers man.

[@quochuynh184]

What an Excel hack! Thanks for sharing!

[@MrSk8erkbw]

Did everything you did, it work for a moment and then quit working. I deleted all formulas and references and tried to start over but no luck, it wont work at all now and I am following you step by step.

[@drwalton4310]

Great video, many thanks. What is the best way to put the drop list on each of the tabs? I have a spreadsheet with many tabs, currenlty there is a link one each back to an Index page. Which contains links to each of the pages. The hyperlink drop-down solution looks/feels far better, so I would like to use this instead

[@190rizwan]

HI A SMALL QUESTION RELATED THIS HYPER+DROP. I LIKE TO DO LINK 114 FILES OF AUDIO WHICH IS SAVE ON DESKTOP. IF ITS WORKING SO PLS LET ME KNOW. THX IN ADVANCE

[@ManojkrishnaJagarlamudi]

It was not working for unhide sheets. Is there any posibility to open the unhide sheets also? Please let me know

[@NeOsageDirector]

This is a really good turorial, thank you; however despite having been through the process I cannot get the last part to work (ie after inserting INDIRECT) into the named reference; the link simply takes me to the cell A1 on the same tab, for all the links in the dropdown. Oddly excel adds 'CONTENTS! into my named reference: =INDIRECT(ADDRESS(1,1,,,CONTENTS!D18)), and even if I remove it, it puts it back in. Any idea what I'm doing wrong? tia.

[@biancagarcia6597]

@Phamineed to add another indirect formula where? Im having the same issue

[@nirmalyamandal4848]

Hello Chester can you help me . I need to create drop down Value like Yes & NO . Then when some one clicks yes . If some one Clicks Yes Value then yes hyperlink Navigate to the Worksheet . If no Choosen nothing gonna happen . It remain in that Cell . Can you suggest or advice something .

[@michaellopez1760]

My sheet page doesn't comeup with quotes after entering the formula

[@TheSeraphrim]

Is there a google sheets?

[@jvamesquita2011]

Can you do this in google sheets?

[@user-sj6qi2yu3o]

HOW ABOUT DROP DOWN LIST - SEARCHABLE AT THE SAME TIME?

[@Shadsix]

This doesn't work when the hyperlink is grayed out and control K doesn't work.