Returning a Hotlink from a VLOOKUP
 

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,

Returning a Hotlink from a VLOOKUP
 

Easy

replace:

=VLOOKLUP()

with:

=HYPERLINK(VLOOKUP))
--
Gary''s Student - gsnu200825


"Rich" wrote:

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,

Returning a Hotlink from a VLOOKUP
 

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" wrote:

Easy

replace:

=VLOOKLUP()

with:

=HYPERLINK(VLOOKUP))
--
Gary''s Student - gsnu200825


"Rich" wrote:

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,

Returning a Hotlink from a VLOOKUP
 

For this technique to work, VLOOKUP() must return the actual URL, not the
"friendly name"
--
Gary''s Student - gsnu200825


"Rich" wrote:

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" wrote:

Easy

replace:

=VLOOKLUP()

with:

=HYPERLINK(VLOOKUP))
--
Gary''s Student - gsnu200825


"Rich" wrote:

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,

Returning a Hotlink from a VLOOKUP
 

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" wrote:

For this technique to work, VLOOKUP() must return the actual URL, not the
"friendly name"
--
Gary''s Student - gsnu200825


"Rich" wrote:

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" wrote:

Easy

replace:

=VLOOKLUP()

with:

=HYPERLINK(VLOOKUP))
--
Gary''s Student - gsnu200825


"Rich" wrote:

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,

Returning a Hotlink from a VLOOKUP
 

Why does it not display:

http://www.armstrongcustomhomes.net


--
Gary''s Student - gsnu200825


"Rich" wrote:

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" wrote:

For this technique to work, VLOOKUP() must return the actual URL, not the
"friendly name"
--
Gary''s Student - gsnu200825


"Rich" wrote:

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" wrote:

Easy

replace:

=VLOOKLUP()

with:

=HYPERLINK(VLOOKUP))
--
Gary''s Student - gsnu200825


"Rich" wrote:

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,

Returning a Hotlink from a VLOOKUP
 

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

Thanks for your help.

Rich

"Gary''s Student" wrote:

Why does it not display:

http://www.armstrongcustomhomes.net


--
Gary''s Student - gsnu200825


"Rich" wrote:

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" wrote:

For this technique to work, VLOOKUP() must return the actual URL, not the
"friendly name"
--
Gary''s Student - gsnu200825


"Rich" wrote:

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" wrote:

Easy

replace:

=VLOOKLUP()

with:

=HYPERLINK(VLOOKUP))
--
Gary''s Student - gsnu200825


"Rich" wrote:

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,