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.

[Chris 53]

Could this be more of a training issue. Can you ask your users to click on the dropdown button on the Name box?

No Macro's just plain standard Excel.

Chris

[damidre]

Thanks Chris, That would have been appropriate, but what i need to do is go to the corresponding range whenever a Zone is picked from the drop down or another way to show the list of branches when the zone is selected from the drop down.

[DBY]

Hello
Try the HYPERLINK function, for example:

Please Login or Register  to view this content.

You will need to select your Region Code (B2) and then click the cell containing the HYPERLINK function.

Hope this does what you're looking for.

DBY

[damidre]

Works Perfectly. Thank you very much DBY, I'm grateful