Create a hyperlink to a hyperlinked cell using Vlookup function

G

Guest

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

cucchiaino

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.
Click to expand...


Perhaps

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

?



( )---cucchiaino
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to lookup hyperlinked cells 1
Creating a VBA Range object from Excel HYPERLINK workbook function 1
VLOOKUP return cell location and hyperlink 0
Using VBA to Activate a Hyperlink 5
Hyperlink Cell to Shape on seperate worksheets 3
Converting a value in a cell to a hyperlink in the same cell via V 4
Val function with contents of a Hyperlinked cell 1
script to hyperlink and reference a cell value in the hyperlink 5

Top