Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can someone fix this hyperlink formula?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink formula | Excel Worksheet Functions | |||
Hyperlink formula | Excel Worksheet Functions | |||
Hyperlink formula | Excel Worksheet Functions | |||
Hyperlink Formula | Excel Discussion (Misc queries) | |||
hyperlink formula | Excel Discussion (Misc queries) |