Hi all,

I have a sheet with a number of hyperlinks in some cells. Some cells are linked and some aren't.

I wanted to do formula in another sheet that would bring up the hyperlink. I have tried the following but it doesn't work.

Any help?

[=HYPERLINK(INDEX(Masterfile!A$7:A$8000,MATCH('Tomb&CaseStudy'!$K7,Masterfile!$FM$7:$FM$7999,0)))]

Thanks,

Daniel