Vlookup and Hyperlinks

[Graham182]

Ok, I've look thought the net and can't yet find an Answer, I think i'll need a macro to work it where i'm more of a Beginner in VBA,

But what i am trying to do is that In Sheet 1 coloum A I have a list of Hyperlink that go to certain Excel spreadsheets.
With in Sheet 2 I have all the details and ID's which will conraspond with some of sheet 1's ID's

I'm trying to Create a Vlookup which will pull from Sheet 1 the Filename. and also the hyperlink

on sheet one is it listed as

91901.xls

at the moment I was just displaying it with Vlookup with a wildcard included =Vlookup("*" & 91901 & "*", Sheet1! A:A, 1, False)
This will bring the file up but when i put Hyperlink in Front it just come up with an error when clicking on it

If anyone can help

Thanks

 

[brianlb]

On this the formula extracts the cell info, but when I click on it(the hyperlink) it says. Cannot open specified file.