VLOOKUP - Hyperlinks

**croeder** · 06-16-2011, 03:43 PM

Simple question, but can't figure this out with my formats.

Have a large database with one of the columns housing company web sites. When I draw from that database using VLOOKUP onto a report, the web site shows up, but the link is not active (but is active in the database)

I need to figure out how to keep this link active since the report is converted into a PDF and emailed to clients. I have looked at the HYPERLINK function, but it seems as if I would have to manually type in the address (i.e. it can't look at a cell value and convert it)

Thank you as always.

**ChemistB** · 06-16-2011, 04:05 PM

Something like

=HYPERLINK(VLOOKUP(A1,Sheet1!$A$1:$B$20,2,FALSE))

should work. I assume the original hyperlink is the full path/url?

**croeder** · 06-17-2011, 06:38 AM

Yes...that works, thank you very much.

**hopeitworks** · 07-04-2011, 03:44 PM

I am sorry to push into this post, but I am trying something similar with no results. I am getting the cannot open the specified file message:
=HYPERLINK(VLOOKUP("jason", calls!A1:A10, 1, FALSE))

I even tried this with the same results:
=HYPERLINK(VLOOKUP("tor", INDIRECT("calls"&"!$A$1:$A$10"),1, 0))

I basically want VLOOKUP to search column 1, A1-A10 on the calls page. Then take the results and assign a hyperlink to it. Any idea as to why I am still getting this message?