hyperlinks in drop down menu
 

I'm building a spreadsheet that will link users to the marketing material for
a range of promotional campaigns. Each campaign is limited to residents of
certain council areas. I currently have three drop down menus that specify
differing conditions. By selecting the council from the first drop down menu
it populates the second menu with the range of campaigns open to that area.
In the third drop down menu I would like it to display links to the different
promotional materials.

I have created a Look up chart for each campaign and can get the drop down
to return the text listed in these areas correctly but it wont provide them
in the form of links. Is it possible to hyperlink the values in the drop
downs or create a go button that will activate these links?

All help will be greatly appreciated as there seems to be no other
topics/threads with info on this!