Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: hyperlink to changing value cell

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

    Default

    Can a cell with a changing value be hyperlinked according to the result in the
    cell? In other words If cell A3 can have
    a result of 1 or 2, can 1=a hyperlink to
    "something" and 2=a hyperlink to "something
    else". In other other words, can 1 cell
    contain more than one hyperlink??????????
    Thank you!!!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I guess you could do something like that below, but you'd have to store your result in another cell (B3 in this case) and use the formula in A3 to refer to it:

    =IF(B3=1,HYPERLINK("c:my documentsbook1",1),HYPERLINK("c:my documentsbook2",2))

    Hope this helps.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could define a name, "goto", referring to =IF($A$3=1,$D$3,$E$3) or =CHOOSE($A$3,$D$3,$E$3) , and enter "goto" in the "Named location in file" field of the Edit Hyperlink dialog.

    [ This Message was edited by: Mark W. on 2002-04-22 10:50 ]

Some videos you may like

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
  •