Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Hyperlink
I am trying to open a file using the following VLOOKUP to obtain the file
name based on the contents of C3 and stored in the Link_Table in column G8+2. =HYPERLINK(VLOOKUP($C$3,Link_Table,G8+2,FALSE)) The file name and path stored in the Link_Table is as follows: L:\Engrdept\New Manuals\Attach-A-Puller (ABP)\Vacuum\MTC Style\Standard\Text Files\abpvcover.pdf Where the L: Drive is on a server named Mtc4\Shared_Files\ I can create a hyperlink in a cell that opens the file OK, but when I look it up it give me an error saying it Cannot open the specified file Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Hyperlink
Maybe...
=HYPERLINK("file:////"&VLOOKUP($C$3,Link_Table,G8+2,FALSE)) But this means your =vlookup() has to return the actual path/filename. =vlookup() won't bring back the hyperlink. bearcat wrote: I am trying to open a file using the following VLOOKUP to obtain the file name based on the contents of C3 and stored in the Link_Table in column G8+2. =HYPERLINK(VLOOKUP($C$3,Link_Table,G8+2,FALSE)) The file name and path stored in the Link_Table is as follows: L:\Engrdept\New Manuals\Attach-A-Puller (ABP)\Vacuum\MTC Style\Standard\Text Files\abpvcover.pdf Where the L: Drive is on a server named Mtc4\Shared_Files\ I can create a hyperlink in a cell that opens the file OK, but when I look it up it give me an error saying it Cannot open the specified file Any suggestions? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Hyperlink
Thanks Dave, this may work. Can't do it now, but I'll give it a try and let
you know if it does not work. "Dave Peterson" wrote: Maybe... =HYPERLINK("file:////"&VLOOKUP($C$3,Link_Table,G8+2,FALSE)) But this means your =vlookup() has to return the actual path/filename. =vlookup() won't bring back the hyperlink. bearcat wrote: I am trying to open a file using the following VLOOKUP to obtain the file name based on the contents of C3 and stored in the âœLink_Tableâ in column G8+2. =HYPERLINK(VLOOKUP($C$3,Link_Table,G8+2,FALSE)) The file name and path stored in the Link_Table is as follows: L:\Engrdept\New Manuals\Attach-A-Puller (ABP)\Vacuum\MTC Style\Standard\Text Files\abpvcover.pdf Where the L: Drive is on a server named âœMtc4\Shared_Files\â I can create a hyperlink in a cell that opens the file OK, but when I âœlook it upâ it give me an error saying it âœCannot open the specified fileâ Any suggestions? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional hyperlink | Excel Discussion (Misc queries) | |||
Conditional hyperlink? | Excel Discussion (Misc queries) | |||
colour due to conditional formatting & hyperlink/shortcut to a directory | Excel Worksheet Functions | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
How can I use HYPERLINK in a conditional statement between sheets | Excel Worksheet Functions |