Excel 2003/2007 Hyperlink & Vlookup Issue

[salmerin]

Ok, so attached is what I am trying to do.
Basically, I have 3 sheets.
Sheet1: Actual working sheet named "MsgArc"
Sheet2: HyperLinks location named Links
Sheet3: Is the List creation named Lables

So, on A1 in MsgArc I have a Data Validation List which B1 will check to see if it contains one of the names of the List called Operations, if so then it will have a look at corresponding column to hyperlink the file.

I do get the supposedly hyperlink but when I try to click on it, I keep getting:
Cannot Open Specified File

I am NOT on a network and my two test files named One.txt and Two.txt are located where my xls/xlsx is located.

I have tried this on excel 2003, 2007 and now 2010

Any ideas?


Thanks

http://hotfile.com/dl/130876686/9bc3e80/MsgArc.zip.html

EDIT: I have tried some examples presented in here and other sites and non have worked! Oh and I don't want to use Macros!

 

[salmerin]

Ok, I figured out the whole thing.
To make it work, I simply had to subtitute the entire "Link destination enclosed in < > for either a file or folder"

Example code:

< file : //C:\Directory/Folder/file.ext >

And VOILA!