Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2005
    Posts
    53
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Creating a hyperlink based on the cell contents

    In Sheet 1, I have a series of cells with text strings. Each text string also appears in Sheet 2. I want to create hyperlinks in Sheet 1 so that clicking on a text string in Sheet 1 jumps to the same string in Sheet 2, regardless of its position in the sheet. Thanks in advance for your help!

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Example Dynamic Hyperlink

    This not the complete answer, but it may give you a possible option.
    It uses Match to determine the row position of the text string in the other sheet
    It uses the Hyperlink function with the address function to build a Dynamic Link
    It does assume that the match is the entire cell content.
    There are variations of a solution to show how the formula is built up.

    Anyway, it's in the attached file.
    If it helps ok, if not (all knowledge is good)
    Attached Files Attached Files
    Andrew

  3. The Following User Says Thank You to AndrewKKWalker For This Useful Post:

    dgoldstein (2011-11-02)

  4. #3
    Star Lounger
    Join Date
    Dec 2005
    Posts
    53
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi Andrew. I tried it out, and I think that will do it -- thanks! Dan

Posting Permissions

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