Copying hyperlink in excel

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
 
D

Dave Peterson

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

=hyperlink(vlookup(...))
 

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

Hyperlink target after sort? 3
Problem with successive Hyperlinking in Excel 2010 5
Very strange behaviour of VLOOKUP in Excel 2010 4
Hyperlink to first blank cell in column? 3
Finding value using greater than, Vlookup, and nested If 2
Copying a Hyperlink 2
VBA to Open Hyperlink(Concatenate) 7
VLOOKUP return cell location and hyperlink 0

Top