There are two parts to a hyperlink:

1. the URL
2. the "friendly name"

The first thing to do is to make sure the two items match, so you see the
URL if you view the cell. Once that is done replace:

=VLOOKUP()
with:
=HYPERLINK(VLOOKUP())

to produce a nice, "clickable" link
--
Gary''s Student - gsnu2007k


"Paul Cook" wrote:

Hello!

I am using VLOOKUP to bring matching data into the relevant field and while it works perfectly bringing the correct text across i lose the hyperlink.

Is there anyway to do make sure the full hyperlink is brought over?