View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
Kapplox Kapplox is offline
external usenet poster
 
Posts: 1
Default VLookup result to be an active hyperlink

Gents,
I wan tyour help on this one. I have 2 sheets on my workbook and on the
first sheet (that I called sheet1) I have a table with a column
containing hyperlinks to an outside focuments.

On the second sheet (sheet2) I use VLookup on a cell and the result is
coming from the column containing hyperlinks. As you may know the
hyperlink I'm receiving on the second sheet isn't active as it's just a
result of a VLookup function. However on sheet1 the hyperlinks are
active.

How to do to make the hyperlinks resulting form my VLookup function
active (a cell on sheet2) as it is on sheet1.

The question should may be "Is it possible to do that?"

Xavier Lopes