Create a hyperlink to a hyperlinked cell using Vlookup function
=HYPERLINK(VLOOKUP(J3,Sheet2!B36:P67,15)) the cell searched by the above
function is hyperlinked to a pdf file. (=HYPERLINK("D:\Documents and
Settings\joa999\My Documents\Nokia0,8764,378,00.pdf", "Nokia Report")
Which is not opening when click it.
|