asked on 1/23/2019

VLookup return Hyperlink information

I am using a VLOOKUP statement and 1 of the columns in the original data contains a Hyperlink, can I carry this hyperlink over into the new cell withouth using a vba type command? I would like to be able to click on the hyperlink from the lookup value inserted into the new cell.

Thank you,

Microsoft Excel Microsoft Office

Last Comment

Norie

1/25/2019

Norie

1/23/2019

You could wrap your VLOOKUP formula for that column in the HYPERLINK worksheet function.

=HYPERLINK(VLOOKUP(A1, Sheet1!A1:D100, 3,0))

Jon Carlson

1/25/2019

ASKER

Thank you for the suggestion. I tried that and it didn't quite work. The Hyperlink that is carried over looks to point to a file rather than a URL. I have attached a file to show what I am seeing. TEST-JWC-2019.xlsx

Norie

1/25/2019

Did you create the hyperlinks using Insert Hyperlink...?

Jon Carlson

1/25/2019

ASKER

No, I copied them from a web page and pasted them in, they work when copied between cells just not when referenced through a formula.

I can explore using the insert method, it's just that the list changes frequently and I will have the manually insert.

So are you saying I can't make this work through the copy/ paste method to insert into the spreadsheet?

What about if I use vba to copy and paste through the vlookup, can I carry the properties that way?

ASKER CERTIFIED SOLUTION

Norie

1/25/2019

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial