ExcelBanter - Create a hyperlink to a hyperlinked cell using Vlookup function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Create a hyperlink to a hyperlinked cell using Vlookup function (https://www.excelbanter.com/excel-programming/330964-create-hyperlink-hyperlinked-cell-using-vlookup-function.html)

Joe questions in Excel

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.

cucchiaino

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

All times are GMT +1. The time now is 01:57 PM.