Dynamic Hyperlink Based on Cell value - Page 3
Attend Excelapalooza
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: Dynamic Hyperlink Based on Cell value

  1. #21
    New Member
    Join Date
    Sep 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Dynamic Hyperlink Based on Cell value

     
    Good Morning,

    I would like to hyperlink cell D12 of sheet1 to where the information was entered on sheet2 (column A:A), based on the value of A12. The data on sheet2 could have been entered anywhere in column A. Below is a formula from several threads that I attempted to alter, but cannot get it to faction correctly. Please help?

    =HYPERLINK("#sheet2!A:A"&MATCH('sheet1'!A12,'sheet2'!A:A,0))

    Thank You!

    -Rob

  2. #22
    New Member
    Join Date
    Oct 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Dynamic Hyperlink Based on Cell value

    Quote Originally Posted by rmmodine View Post
    Good Morning,

    I would like to hyperlink cell D12 of sheet1 to where the information was entered on sheet2 (column A:A), based on the value of A12. The data on sheet2 could have been entered anywhere in column A. Below is a formula from several threads that I attempted to alter, but cannot get it to faction correctly. Please help?

    =HYPERLINK("#sheet2!A:A"&MATCH('sheet1'!A12,'sheet2'!A:A,0))

    Thank You!

    -Rob
    Is there a way to take the hyperlink from one cell in a sheet in another excel workbook and the text you would like to appear in the cell from another cell rather than entering in the text that you would like to appear?

  3. #23
    New Member
    Join Date
    Dec 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Dynamic Hyperlink Based on Cell value

    Hi,

    If the sheet name is dynamic how we can give a cell reference instead of "#MGP4!". Friendly name also dynamic.

    =HYPERLINK("#MGP4!A"&P2),"MGP4")


  4. #24
    New Member
    Join Date
    Dec 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Dynamic Hyperlink Based on Cell value

      
    Maybe I am just dense, but this doesn't work for me as for others. (a) Why is there a letter "A" in this formula -- I never saw it in the question asked. Is this a presumption that this is worksheet A in workbook named MGP4, and if so what does the # sign mean? I think the users on this site are way beyond me, though I have been using Excel for several decades. Thanks in advance.

    =HYPERLINK("#MGP4!A"&P2)

    You can add a second argument for the text to display if you want.[/QUOTE]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com