Can someone fix this hyperlink formula?
Hi
make this
=HYPERLINK("'[your_file_name.xls]Teams'!" &
ADDRESS(MATCH(C3,Teams!$A$1:$A$10000,0),1),C3)
--
Regards
Frank Kabel
Frankfurt, Germany
Tony wrote:
Hi Frank,
That was a quick reply.
I tried your formula but I got a message saying 'Cannot
open the specified file'.
Any suggestions?
Tony
-----Original Message-----
Hi
maybe
=HYPERLINK("'Teams'!" & ADDRESS(MATCH(C3,Teams!
$A$1:$A$10000,0),1),C3)
--
Regards
Frank Kabel
Frankfurt, Germany
Tony wrote:
Hi Group,
Worked at this for ages. Can someone fix this hyperlink
formula for me - it won't jump to the correct worksheet
called Teams - it just goes down the worksheet that it is
currently on called League. Also, can it be shortened?
=HYPERLINK(MID(CELL("filename",$A$1),FIND("[",CELL
("filename",$A$1)),FIND("]",CELL("filename",$A$1))-FIND
("[",CELL("filename",$A$1))+1) & ADDRESS(MATCH(C3,Teams!
$A$1:$A$10000,0),1),C3)
Many thanks
Tony
.
|