Hyperlinks and VLOOKUP Error

Hi Glenn,

Essentially, I have two problems as shown in the attached.

1. In Column H, I want to reference the rows in CPT2015 Tab (B7-B9). I want it to work as a link and not just show the text. Right now, Rows H5:H7 just shows the text. The resulting data would be my index of tabs/files.

2. After creating the index, I want the search engine to display the results from filtering through the resulting index data.
Right now, I hard-coded the Index of Projects (Column C). After the results are displayed, I want it to work as a hyperlink, but it shoots off the error ("Cannot open the specified file.").

Test.xlsm

Thank you for your help.

Hi Glenn,

My apologies. I just saw your previous post. I think my error is because of the search engine created.
I am interested in just having the search results in hyperlink form work if my data is hyperlinked on the same tab.
Test.xlsm

Please see attached. Thank you so much for your help.