Would like to link a hyperlink

Dear All,

I am trying to link a hyperlink in one sheet to another cell in different sheet. I understand one should not use a vlookup as it only returns you the text in the hyperlink cell and not the actual hyperlink. So i am using the Hyperlink formula however when i click on the hyperlink i get a message telling me "Cannot locate the Internet server or proxy server".

Please see below for my formula:


=IF($D$4="","",HYPERLINK(VLOOKUP($D$4,Summary!$A$6:$EO$152,MATCH("Hyperlink Manager Factsheet",Summary!$A$6:$EO$6,0),FALSE),"CLICK HERE"))

I have tested the vlookup part of the formula with "=VLOOKUP($D4,Summary!$A$6:$EO$152,MATCH("Hyperlink Manager Factsheet",Summary!$A$6:$EO$6,0),FALSE)" and that returns the text in the hyperlink cell which would indicate that part of the formula works. As far as i can see the hyperlink part of the formula works aswell.. any ideas ?

I have also made sure the hyperlink itself self works.

Thanks for any help