Hyperlinks

  • Thread starter Thread starter Spencer
  • Start date Start date
S

Spencer

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
 
Back
Top