Referencing a Named Range or Sheet dynamically

[damidre]

Good day Guys, I have a challenge I'm trying to surmount. I have an excel sheet in which I want to be able to select Zone codes from a drop down, click on a link "search" which takes me to a place in the document that has been named according to the Zone code i pick in the drop-down. I want to achieve this using only formulas as i'm distributing the file to a wide audience who are not versed enough with computers to know how to enable macros. I have attached a sample of what i'm trying to describe. Your help will be much appreciated.

[ratcat]

G'day,

Courtesy of our local mad rocket scientist Jerry Beaucaire, he has supplied this to the www

Without typing half of page of badly explain information about what I did. Just simply download the attachment then ask questions if needed.

[damidre]

Thanks a lot