View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe questions in Excel Joe questions in Excel is offline
external usenet poster
 
Posts: 1
Default 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.