+ Reply to Thread
Results 1 to 3 of 3

Hyperlink cell based on value

  1. #1
    Registered User
    Join Date
    10-14-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Question Hyperlink cell based on value

    I am having a sheet in which I want to hyperlink a cell such that it finds text mentioned in formula and moves cursor there

    For this I am using below formula
    =HYPERLINK("#ToDo!A" & MATCH("promc1",A:A,0), "display text")

    Above formula is entered in cell A53

    Todo is sheet name in the same worksheet
    promc1 is the text which need to be find
    dislplay text is the text should be visible in A53

    What is perfect: When i click link on A53, it will find promc1 in A and wherever it finds promc1 it will take the cursor there.

    Problem is: instead of "display text" in A53 it shows zero

    Attached screenshots

    I am using MS Office 10 in windows 10

    Please help in solving there
    Attached Images Attached Images

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Hyperlink cell based on value

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    As you are new I will add it for you this time

    https://www.mrexcel.com/forum/search...rchid=10392075

  3. #3
    Registered User
    Join Date
    10-14-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Re: Hyperlink cell based on value

    The issue is resolved.

    Solution: Try moving the formula to another column, maybe B53.
    With the formula in col A you will get a circular reference, which is probably causing the problem.

+ 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. Hyperlink based on cell value
    By rbv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2017, 04:43 PM
  2. Hyperlink based on cell value
    By rbv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2017, 10:08 AM
  3. Macro to add individualised hyperlink to cell based on cell contents
    By DaCor1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2016, 04:26 PM
  4. External cell reference based on hyperlink in a cell in the active sheet
    By Sydstar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-29-2014, 08:25 AM
  5. Hyperlink based on cell value
    By killerthun in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2014, 06:41 PM
  6. hyperlink based on value of the cell
    By darkhangelsk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-09-2014, 02:41 PM
  7. Replies: 1
    Last Post: 08-06-2013, 02:47 AM

Tags for this Thread

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