Copying hyperlink from one cell to another within a formula

  • Thread starter Thread starter Heath
  • Start date Start date
H

Heath

Windows 2000 Pro and Excel 2000

I have a worksheet with a table of information, included in this table
are hypolinks.

First colunm of the table is a ref number.
Secound is a discription.
Third has different URL's
(There are other colunms)

Secound worksheet has a colunm where I enter the ref number and the
following cells self populate from that ref number useing the
following

=VLOOKUP(B24,Intro!G33:L192,2,0)

However this only populates the new cells with the text from the first
sheet
and doesn't insert the hyperlinks.

Any idea how I can get it to transfer the hyperlinks as well as the
displayed
text.
 
"Heath"

Wrapping the formula in the HYPERLINK function worked for me, eg:

=HYPERLINK(VLOOKUP(D1,$A$1:$B$2,2))

HTH,
Andy
 
Back
Top