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