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?
|