Paul,

Lets say we have a list of web sites and their full addresses in sheet 2 in
columns A & B. Here's and example of that data for Google

Col A Col B
Google http://www.google.co.uk/


Try this in sheet 1

=HYPERLINK(VLOOKUP(A2,Sheet2!A1:B30,2,FALSE),A2)

Where A2 is the site to lookup (Google)

Mike

"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?