Here is the formula I am using in cell E3 of Worksheet B:

=INDIRECT("'potentials'!s2")

This will pull from cell S2 in Worksheet A, which has this formula in it:

=HYPERLINK("http://www.somewhere.com/abscd.asp?addrs=" &R:R )

Column R:R has the 12345678 values in it from cell 2 to infinity.

I need for this to display as a clickable html link to that website in
Worksheet B.

Thanks again!

Norberto

"SteveG" wrote:


I created a sheet named A, B & C.

In Sheet A, I entered in cell A1 "B2". In sheet B, cell R2, I entered
=INDIRECT(A!A1) which returned the value in cell B2 of Sheet A which in
this case is 12345678.

Does the above describe basically what you are doing? If so.

In Sheet B, S2 I entered,

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

This returned a named hyperlink of 12345678 that when clicked opened
Exceltip.com.

I may be missing something. If you could provide your formulas and
data, I could take a look.

Steve


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