Hi Guys,

I need to use Vlookup to look up hyperlinks from one spreadsheet to another
each month. I have too many to do a cut and paste.

When I do the Vlookup however I lose the link.....it shows up but it does
open.

Is there anyway to do this

Maybe you could use:

=hyperlink(vlookup(....),"Click me!")

If the value you're retrieving looks like a real hyperlink address.

or maybe...
=hyperlink("Http//" & vlookup(....),"Click me!")

Depending on what that value returned is???


sdurso wrote:

Hi Guys,

I need to use Vlookup to look up hyperlinks from one spreadsheet to another
each month. I have too many to do a cut and paste.

When I do the Vlookup however I lose the link.....it shows up but it does
open.

Is there anyway to do this

--

Dave Peterson

Hi,

Maybe:.

=HYPERLINK(vlookup formula)

HTH
Jean-Guy



"sdurso" wrote:

Hi Guys,

I need to use Vlookup to look up hyperlinks from one spreadsheet to another
each month. I have too many to do a cut and paste.

When I do the Vlookup however I lose the link.....it shows up but it does
open.

Is there anyway to do this

Thanks Dave,

This still doesn't seem to work......the link comes over but does not open.
I'm linking to a document that is on our network if that makes a difference

"Dave Peterson" wrote:

Maybe you could use:

=hyperlink(vlookup(....),"Click me!")

If the value you're retrieving looks like a real hyperlink address.

or maybe...
=hyperlink("Http//" & vlookup(....),"Click me!")

Depending on what that value returned is???


sdurso wrote:

Hi Guys,

I need to use Vlookup to look up hyperlinks from one spreadsheet to another
each month. I have too many to do a cut and paste.

When I do the Vlookup however I lose the link.....it shows up but it does
open.

Is there anyway to do this

--

Dave Peterson

Here is a neat trick, it can be used on structures other than VLOOKUP():

=IF(1=2,HYPERLINK("",""),VLOOKUP())

Obviously because 1 can never equal 2 the dummy hyperlink can never be
executed, but Excel now expects a hyperlink from VLOOKUP!
--
Gary's Student
gsnu200701


"sdurso" wrote:

Hi Guys,

I need to use Vlookup to look up hyperlinks from one spreadsheet to another
each month. I have too many to do a cut and paste.

When I do the Vlookup however I lose the link.....it shows up but it does
open.

Is there anyway to do this

Maybe...

=hyperlink("file:////" & vlookup(....),"Click me!")



sdurso wrote:

Thanks Dave,

This still doesn't seem to work......the link comes over but does not open.
I'm linking to a document that is on our network if that makes a difference

"Dave Peterson" wrote:

Maybe you could use:

=hyperlink(vlookup(....),"Click me!")

If the value you're retrieving looks like a real hyperlink address.

or maybe...
=hyperlink("Http//" & vlookup(....),"Click me!")

Depending on what that value returned is???


sdurso wrote:

Hi Guys,

I need to use Vlookup to look up hyperlinks from one spreadsheet to another
each month. I have too many to do a cut and paste.

When I do the Vlookup however I lose the link.....it shows up but it does
open.

Is there anyway to do this

--

Dave Peterson


--

Dave Peterson