Hyperlink formula returning 'invalid site address'

[MarkH]

I am trying to include 'hyperlink' inside a formula but am encountering difficulties. Even when I use just hyperlink as a formula on its own, it accepts the formula but returns an error message.
Ultimately the user will select a month from a drop down list, the hyperlink will take them to the relevant sheet (one for each month), any help in achieving this would be much appreciated.
Thanks from a newbie.



Hi All
I think I have found the solution on another site. You need to include the # symbol at the beginning of the formula argument to direct it to a local sheet. So for example the expression would look like this =HYPERLINK("#"&J7&"!"&"A1","Sheet 7")
This detail is not included in the Microsoft Help material.
Hope this helps someone else.