Returning a Hotlink from a VLOOKUP

[Rich]

I have a cell with a dropdown list of Company names. When I select a name,
the adjacent cell returns the URL for that company via a VLOOKUP function.
It all works fine except that the URL it returns is not a hotlink to that
website. How can I make it return a useable hotlink?

Thanks,

 

[Gary''s Student]

Easy

replace:

=VLOOKLUP()

with:

=HYPERLINK(VLOOKUP))

 

[Rich]

Gary's Student,

thanks for the help. It works great to retrieve the URL in blue and
underlined. However, when I click on the link it says "Cannot open the
specified file". I tried it with 3 different hyperlinks.

 

[Gary''s Student]

For this technique to work, VLOOKUP() must return the actual URL, not the
"friendly name"

 

[Rich]

Not sure what a "friendly name" is, but it is underlined, blue and of the
format: www.armstrongcustomhomes.net. However, when I click on it I get the
message "cannot open the specified file".

 

[Gary''s Student]

Why does it not display:

http://www.armstrongcustomhomes.net

 

[Rich]

That did it! I just had the www.....

Thanks for your help.

Rich