Hyperlink in vlookup function?

I'm trying to make a hyperlink in particular sheet so that when I click the hyperlink it will redirect me to that worksheet. The problem is, if I would do it one by one it takes a lot of time really... i'm just wondering if i could use the vlookup function in hyperlink... i'm trying this formula:

=HYPERLINK(VLOOKUP(a1,'[table.xls]shee...

but everytime i click the hyperlink, an error message appear:

"cannot open specified file"...

pls help.... anyone???

Hyperlink in vlookup function?windows media center

What you want to do is make a list of hyperlinks then just name the hyperlinks this is how it will look like,

=HYPERLINK("[C:\Documents and Settings\???\My Documents\list.xls]none!A10","none page")

[C:\Documents and Settings\???\My Documents\list.xls]-Opens the workbook

none!A10- Opens the sheet page and cell

"none page")- This is the name of the hyperlink.

Once you have all of your hyperlinks down a column filter and use the filter options as a lookup.