Dynamic Hyperlink from two cells

**Atticus_Finch** · 11-07-2013, 02:44 PM

I would like to combine two cells to make a valid hyperlink. The first cell contains the portion of the web page which is always fixed. The second cell adds a product code. When the two are put together the right web link is sourced.

Here's what doesn't work:
=HYPERLINK("#Start!WebKey"&M11,"RelatedDocuments")

It ignores the second cell reference entirely. When I examine the hyperlink were I expect the value of M11 I get ,m11 instead.
Then I tried to insert a value function and the cell prints the value correctly, but the hyperlink is still wrong (Picture).

If someone can point me to a solution I would appreciate this.
HyperlinkIssue.jpg

**martindwilson** · 11-07-2013, 02:56 PM

=HYPERLINK("#Start!WebKey"&M11,"RelatedDocuments")
as it stands wont work as the # tells it the link is in the same workbook so would be invalid

i dont get that problem with text eg
=HYPERLINK("http://www.ebay.co.uk/sch/Fitted-Carpets-Underlay"&C1,"test") where c1 contains /175820/i.html

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**Atticus_Finch** · 11-07-2013, 03:54 PM

I tried using a workbook link instead of a sheet link and this is functional, which solves my problem.
Either there is a problem with Sheet designations or I have a sheet reference syntax problem.