Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Hyperlink (2000)

    I haven't been successful in executing a conditional hyperlink whereby if the statement is True then ordinary (non-hyperlinked) text is placed in a cell and a False results in a hyperlink. Here is the formula I am using:
    =IF(VLOOKUP(CONCATENATE(A2,B2),revapp1,4)="Coincid es with Approval","Coincides with Approval",HYPERLINK(VLOOKUP(CONCATENATE(A2,B2),rev app1,4)))

    Even when the condition is True, the text (Coincides with Approval) appears as a hyperlink.

    Anyone know how to make this work?

    Thanks,
    Howard

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Hyperlink (2000)

    Howard

    I can repeat your experience - and cannot stop the behaviour by any clever combinations of IFs inside, or outside HYPERLINKs.

    However, if I substitute the formula with

    =HYPERLINK(C1)

    and then place an if in C1 such as

    =IF(A1,"","http://www.wopr.com")

    I think I have a workaround (I use 2002) - although all my hyperlinks were giving me a "cannot find server" message at the time.
    HTH

Posting Permissions

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