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(...))



Ofer wrote:
>
> 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
>

--

Dave Peterson