I am sure there is a solution in VB but if you want to use a
formula....

You could do it so that Column S contains the Hyperlink. In S2

=IF(R2=12345678,HYPERLINK("http://www.exceltip.com",R2),"")

In the HYPERLINK formula, the address http//... needs to be in quotes
if you are typing in the address. The R2 references the name that will
appear in the cell containing you link. Or you could use cell
references as the path name. Type in your address
http://www.exceltip.com in cell T2 say. Then your formula would be.

=IF(R2=12345678,HYPERLINK(T2,R2),"")

In either case, it still requires the user to click on the newly
created link to be forwarded to the site.



HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=497982