Hyperlinks
in [General]
|
From: Spencer on 12 Mar 2010 14:29 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?
From: Gord Dibben on 12 Mar 2010 15:17 =HYPERLINK(VLOOKUP(A1,lookup_table,2,FALSE),"mylink") Gord Dibben MS Excel MVP On Fri, 12 Mar 2010 11:29:02 -0800, Spencer <Spencer(a)discussions.microsoft.com> 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?
From: Dave Peterson on 12 Mar 2010 15:29 =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
|
Pages: 1 Prev: import from files with data in ieee floating point format Next: Excel opening cell |