I am trying to use a Vlookup to pull a Hyperlink from a table, into another
cell. At this poing I cant seem to get the hyperlink to copy over as well. Is
there anyways that I can have this work?

=HYPERLINK(VLOOKUP(A1,lookup_table,2,FALSE),"mylin k")


Gord Dibben MS Excel MVP



On Fri, 12 Mar 2010 11:29:02 -0800, Spencer
wrote:

I am trying to use a Vlookup to pull a Hyperlink from a table, into another
cell. At this poing I cant seem to get the hyperlink to copy over as well. Is
there anyways that I can have this work?

=vlookup() will return the value from the cell--not the hyperlink.

If you're lucky, you could be returning a nice URL, like:
http://www.microsoft.com

And then you could use a different cell:
=hyperlink(a1,"click me")
or
=hyperlink("http://" & a1,"click me")
if you were returning: www.microsoft.com



Spencer wrote:

I am trying to use a Vlookup to pull a Hyperlink from a table, into another
cell. At this poing I cant seem to get the hyperlink to copy over as well. Is
there anyways that I can have this work?

--

Dave Peterson