How to use Hyperlink function from drop down menu data validation list throughout entire workbook

How to hyperlink function from a drop down menu data validation list, hyperlink anywhere in a workbook and on any cell on the page from one list. This is very simple to use and will help locate anything on your list throught the workbook.

On formula tab In yellow: Any B4 should say B9

[eekenulv]

so simple and straightforward!
just what we needed in our project!

[lucazanetti]

Hi everyone. I had to change from &B9, "GO" to &B9;"GO" in order to make the function name the cell as GO or anything else!
Hope this will help someone.

btw, thank you very much for sharing! This helped my work!!

[nicholaswhite]

As much as I hated your ELI5 approach (maybe it's your voice?), you did give me another perspective on how to solve a problem I'm working on. So for that, thank you sir. 

[djacobson]

Gary,

Question 1: Unfortunately, I have not found another way of doing this except using the "GO" step.
Question 2: That is a good question, I will have to look into that. What I do is use a hyperlink button on each sheet throughout the workbook at the top corner of the page that is named "MAIN MENU". This makes it easy to go back the the drop-down list sheet after hyperlinking from it. This seems to be working fine for me.

I hope this helps.

Thanks

Doug

[vilashshah]

Done. Sorted.. Thanks for this Idea....

[ronnie.creamer]

Yes I need to get into my warrior Plus account

[MrMinties]

Hay,
I am working in windows 10 version of Excel and so when I click on the drop box consisting of my Abc list all that comes up in the drop down list is the name "Abclist". Can you tell me why rest of the list is not comming up as well ie a, b, c, d, e, , f under the Abclist heading?

[frcreation]

Nice Video. I's also possible to have "GO" by choosing the item from the list?
Now you select first some item for the list and then you give the command.
But can it be without this specific comment and directly?

[obspugs]

When I click in my "Go" box, it refers me up to B9 instead of linking to the cell I've indicated. Why is that? I've been working on this all day and I can't figure out what's wrong. My formula is the same as listed in the video, but with my information. Everything in the drop down is there. I'm thinking it has something to do with the hyperlinked cells?? But I'm not sure, it all appears the same. Help!

[garyjeffersonabot]

FYI, the link refers to other workbook...I want to open a different workbook using a drop down list with hyperlink on it.

[garyjeffersonabot]

Is it possible to make a hyperlink for every list in a drop down without changing the List Caption?
example:
but the link is hidden or only the caption is shown in the list.Because on other tutorials they immediately put the address on the dropdown list.What Im trying to make is the caption only with the hyperlink hidden.Is it possible or is there any other way I can do the result?

Hoping for your immediate response, your idea is a BIG HELP.Thank You!

[HarvestrX]

Refernce is not valid! I've typed it in just as you all have it and I get this. If I chance &B2, "GO" to &"B2", "GO" I links to the actual menu tab, but I can not for the life of me link to anything IN the menu. MS apps make life hell. You can't get shit done with them as they never friggin work!

[Steevels]

Is there a way to change the "GO" into a button?

[junfan]

Hi, is it possible to have hyperlink function from drop down menu data validation list but going into different excel files and not just throughout the entire workbook? Thanks in advance.

[markgeer]

hey can I talk you into how to do the same thing but with hyperlinks going to folders on your hard rives that have videos. So basically a dropdown menu that triggers internal video links on your hard drive to play. I would pay you to do that no joke.

[HarleyEsguerra]

Hello - I tried the formula you outlined but I am getting a "Cannot open the specified file" error message. I looked at the file names and spelling 50 times but I dont see anything. Do you know how I can fix this?

[jamesjohnny]

how about if using different workbook, how to link drop list?

[ClaudiaShifferLA]

Doesn't work for me, something is missing in the video

[liberax]

Is it possible to make the items in drop down list hiperlinks so I could just click on the item?

[ramiqumri]

Do you know how to hyperlink from a dropdown list to a hidden sheet?