Thank you for responding, Steve. The solution you offered does work. However,
I neglected to mention that I am using an INDIRECT formula to pull the data
from a separate worksheet. In other words, my spreadsheet has numerous
worksheets. Worksheet A has all of the data. Worksheets B-F display and
reference data from Worksheet A to perform various formulas. Now, the data
from column S:S is populating in Worksheet B as an "http://..." but in plain
text, not a hyperlink. Is there anyway it can show in Worksheet B as a
clickable hyperlink?

"SteveG" wrote:


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