hyperlink to changing value cell

[Julie T]

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!!!

[Mudface]

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.

[Mark W.]

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 ]