Back to Index

EXCEL 2010-2007 : VLOOKUP and hyperlinks

I retrieve a cell with a hyperlink through the VLOOKUP function : no link - error message : "cannot open the specified file"

1. The VLOOKUP function only returns the data - never the hyperlink

You must include the VLOOKUP into the HYPERLINK function
As this : =HYPERLINK(VLOOKUP(A26;$A$1:$B$5;2;FALSE))

2. How you typed or created the hyperlink (source cell) is most important and makes the difference !

Explanations through the screen captures below :

Two lists : index column and columns with manually typed hyperlinks

Links returned by the VLOOKUP function : they don't work

Solution : the link must show the full adress and not only the text to display

© Copyright : Office Doc / Web development by Office Doc