Conditional Hyperlink (2000)

[lornhow]

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

[AndrewO]

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