+ Reply to Thread
Results 1 to 4 of 4

Using Hyperlink with INDIRECT

  1. #1
    Registered User
    Join Date
    05-20-2020
    Location
    Soc Trang, Vietnam
    MS-Off Ver
    2016
    Posts
    2

    Using Hyperlink with INDIRECT

    i saw something posted years ago that was similar but much more complicated than my needs.

    i want to 'goto' (hyperlink) to a cell reference that is in another cell (indirect)

    note i do not want the cell contents. i have that and that is easy.

    having searched/found a match, i then want to 'jump to' that cell

    ie instead of always having enter different F5 Goto values

    ok

    the cell containing the cell reference i want to jump to is in $e$3.

    so i want to click on a hyperlick cell next to e3, ie f3, and that will take me to the cell referenced in e3.

    many thanks

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,482

    Re: Using Hyperlink with INDIRECT

    Try:
    Please Login or Register  to view this content.
    Quang PT

  3. #3
    Registered User
    Join Date
    05-20-2020
    Location
    Soc Trang, Vietnam
    MS-Off Ver
    2016
    Posts
    2

    Re: Using Hyperlink with INDIRECT

    wow! so simple and so good!

    i look other examples, but i do not one like that.

    many thanks

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,482

    Re: Using Hyperlink with INDIRECT

    You are welcome.
    here is the link for your ref:
    https://superuser.com/questions/1371...sing-a-formula

+ 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. Issues with Hyperlink and INDIRECT
    By BSGUK in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-17-2018, 06:45 AM
  2. Hyperlink using indirect function
    By Lakeyyy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-21-2016, 07:51 AM
  3. [SOLVED] INDIRECT function within a hyperlink
    By Otteralum in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2015, 09:09 AM
  4. Hyperlink Indirect To Another Sheet
    By Padsensor in forum Excel General
    Replies: 6
    Last Post: 05-14-2012, 04:20 AM
  5. How to setup a hyperlink to an indirect function?
    By Max in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 09-06-2005, 12:05 PM
  6. How to setup a hyperlink to an indirect function?
    By Skot in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  7. [SOLVED] How to setup a hyperlink to an indirect function?
    By Skot in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

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