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