Thread: Create a hyperlink to a hyperlinked cell using Vlookup function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
cucchiaino cucchiaino is offline
external usenet poster
  
Posts: 28
Default Create a hyperlink to a hyperlinked cell using Vlookup function
Joe questions in Excel:

=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.


Perhaps

=HYPERLINK(VLOOKUP(J3,Sheet2!B36:P67,15),0)

?



( )---cucchiaino
Reply With QuoteReply With Quote