T
Tony
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
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