| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP returning #N/A | Excel Worksheet Functions | |||
| Can I create a hotlink to go from one cell to another in a wrksht | Excel Discussion (Misc queries) | |||
| Vlookup Returning #n/a | Excel Worksheet Functions | |||
| Vlookup returning #N/A | Excel Worksheet Functions | |||
| Vlookup and returning #n/a | Excel Worksheet Functions | |||
Linear Mode
