Vlookup with hyperlink function appearing to work, but giving error when you click on the result

Question

I have a spreadsheet I am building that has a master sheet with standard client data and a working sheet that is updated daily and pulls information from the master sheet using a vlookup function. On the master sheet are a number of columns that have a link to a file stored on a shared drive. The hyperlinks on the master sheet all work correctly, however when I try to click on the vlookup result in the daily working sheet, the link results in the following error: "An Unexpected Error Has Occurred"

Looking for help with a resolution!

Here is the formula I am currently using:

=HYPERLINK(VLOOKUP(A5,Table3[#All],7,FALSE))

Table3 is on the Master tab and the hyperlink to my file is located in column 7 therein

Thank you!

Answer 1

If your column 7 is file path, then hyperlink formula will work.