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