Hyperlinks - Function Output

[croeder]

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.

Thank you as always.

 

[VoG]

Try

=HYPERLINK(your formula)

 

[croeder]

From my sheet that I just tried:

=HYPERLINK(VLOOKUP(A3,E4:F5,2))....not returning me a value?

 

[VoG]

Does

=VLOOKUP(A3,E4:F5,2

return a value? If so what does it return?

 

[croeder]

Yes....it returns a web site address, but the not active as a hyperlink (the problem I am trying to solve).

When I type in =HYPERLINK(VLOOKUP(A3,E4:F5,2)), it just shows as text. Maybe I am using the function wrong?