Using Vlookup to pull hyperlink from Master Hyperlink file list.

I'm somewhat knowledgeable of excel, im just starting to get into visual basic but am very inexperienced. I'm using a macro to pull a list of files in a folder that get hyperlinked to the specific file. Now i want to cross reference these hyperlinks in another sheet on the same workbook. but am having trouble pulling the hyperlink with vlookup. searching forums and such looking for a solution to this problem and have come up empty handed.

Here is the formula i am using,
=HYPERLINK(IF(ISNA(VLOOKUP(A27,'book2'!A:B,2,FALSE)),"",VLOOKUP(A27,'book2'!A:B,2,FALSE)))

It shows the cell contents and it has hyperlink status but when clicking on the cell i get an error "cannot open specified file". Is theres something i am missing or is this not possible to do?

Any insight would be greatly appreciated.