Hyperlink retured through a VLOOKUP gives error

[Andrew80284]

I have created several worksheets including one that holds my look up tables (worksheet labeled tables). I also have another worksheet called "Directions". In the "Tables" worksheet I have an array with three columns, the first holding the text value I am searching for, column two which contains hyperlinks to Worksheet three, and Column three which contains hyperlinks to Worksheet 4.

=HYPERLINK(VLOOKUP(C7,Tables!E2:G10,2,0))

The formula returns the hyperlink, but when you click on the link an error message pops up saying "Cannot open the specified file". The hyperlink works from the Tables page directly, but not when returned with the HYPERLINK(VLOOKUP function.

Any help would be greatly appreciated.

Thank you,
Andrew

 

[DanteAmor]

Re: Hyperlink retured through a VLOOUP gives error

Try this

=HYPERLINK("#" & VLOOKUP(C7,Tables!E2:G10,2,0))

 

[Andrew80284]

Re: Hyperlink retured through a VLOOUP gives error

Try this

=HYPERLINK("#" & VLOOKUP(C7,Tables!E2:G10,2,0))

Tank you DanteAmor, but this gives me the same error

 

[Andrew80284]

Re: Hyperlink retured through a VLOOUP gives error

Try this

=HYPERLINK("#" & VLOOKUP(C7,Tables!E2:G10,2,0))

Thank you DanteAmor, but this gives me the same error

 

[Andrew80284]

Re: Hyperlink retured through a VLOOUP gives error

Try this

=HYPERLINK("#" & VLOOKUP(C7,Tables!E2:G10,2,0))

Thank you DanteAmor, but this gives me a "Reference isn't valid" error.

 

[DanteAmor]

Re: Hyperlink retured through a VLOOUP gives error

Thank you DanteAmor, but this gives me a "Reference isn't valid" error.

Ok check my test file

https://www.dropbox.com/s/ami4em6p9hxj0am/example hyperlink dam.xlsm?dl=0