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

VLookup result to be an active hyperlink
 

Hey Kapploz

You can try the hyperlink function. The syntax would look like,

=HYPERLINK(VLOOKUP(C6,Sheet2!$A$4:$D$6,4,FALSE))

Rgds
Joham

Kapplox wrote:
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

--
Message posted via http://www.officekb.com