Hi everybody!

I am making some kind of a search engine in excel. The search engine is placed in an "output worksheet" that pulls out information from an "input worksheet". It works well, pulling out all information from the input worksheet, even hyperlinks. The only problem, which is kind of a big problem, is that the hyperlinks does not work as they do in the input worksheet. I just get the message: "Cannot open the specified file".

I use the following formula in the output sheet to pull out the hyperlinks: =IFERROR(HYPERLINK(INDEX(Table1[Hyperlink];MATCH('Output (Values) '!F5;Table1[Agreement name];0)));"")

If anybody has any suggestions on how to solve this problem, I would be so greatfull.

Andreas