Copying hyperlink in excel

  • Thread starter Thread starter Ofer
  • Start date Start date
O

Ofer

Hi,

How do I get a cell with a hyperlink to a webpage to pass through a VLOOKUP
formula?

I'm running office 2000. in one sheet I have data in which one column
contains cells with hyperlink to WebPages.
In another sheet I use the VLOOKUP formula to return a cell from that
column. only the value of that cell is returned but not the hyperlink.

With copy\paste the hyperlink pass through, but with VLOOKUP or even when i
use direct link (value of cell A3 is "=A4") it doesn't work.

Need help fast!!!

Thanks

Roncho
 
If you're returning the actual link (not the friendly name), maybe you could
embed it into your function:

=hyperlink(vlookup(...))
 
Back
Top