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?

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

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