+ Reply to Thread
Results 1 to 2 of 2

Creating Dynamic Hyperlink within Excel Same Sheet

  1. #1
    Registered User
    Join Date
    02-27-2009
    Location
    saco
    MS-Off Ver
    Google Docs
    Posts
    57

    Creating Dynamic Hyperlink within Excel Same Sheet

    I have a sheet that I want to have link to the cell within the same sheet.

    I want to link the following Phone names to the second image cell.

    https://i.imgur.com/4ovzMpL.jpg

    https://i.imgur.com/lWfbJ6z.jpg

    Above is list of phones

    I read this and attempted it but this did not work for me.

    =HYPERLINK("#MyRange","Shift to there")


    My formula in cell M2

    =INDEX($C$2:$C$70,MATCH(N2,$I$2:$I$70,0))

    And this

    =HYPERLINK(VLOOKUP(M2,'Copy of Phones DP'!phones,1,0),M2)
    This one links me to a new tab and searches for the following
    http://galaxy%20s9+%2064gb/
    The expected outcome would be When i click on the phone name in column M it goes to the phone row in column C

  2. #2
    Registered User
    Join Date
    02-27-2009
    Location
    saco
    MS-Off Ver
    Google Docs
    Posts
    57

    Re: Creating Dynamic Hyperlink within Excel Same Sheet

    Ok so im getting close

    I use the following
    PHP Code: 
    =HYPERLINK("#" CELL("address",INDEX(C2:C64,MATCH(M3,phoneName,0))),B5
    It does not go to the cell but the URL changes in google sheets to

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating a dynamic hyperlink to a different sheet in the same workbook.
    By Ribband in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-21-2018, 09:57 AM
  2. Creating a Hyperlink on a dynamic cell
    By HGL in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2016, 11:20 AM
  3. Creating a dynamic graph in a different excel sheet
    By Jarron in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-21-2015, 10:09 PM
  4. [SOLVED] Creating Hyperlink to new sheet
    By rigby in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2013, 02:10 AM
  5. Creating a dynamic hyperlink by matching a value
    By bvknight in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-31-2011, 05:01 PM
  6. Hyperlink function using a dynamic sheet name
    By skysurfer in forum Excel General
    Replies: 0
    Last Post: 07-25-2011, 04:25 PM
  7. Creating Dynamic Folders/WorkBook from a Sheet with Dynamic Path.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-28-2011, 05:42 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1