Hyperlinks

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?
 
D

Dave Peterson

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top