Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks
I am creating a document that when you choose an option, it displays the
hyperlink. I tried using the Vlookup function, but it only returns the value of the cell and not the acutal hyperlink. Any thoughts on how to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks
Hi,
try the HYPERLINK function: =HYPERLINK(A1) where A1 contains your hyperlink. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Chris B" wrote: I am creating a document that when you choose an option, it displays the hyperlink. I tried using the Vlookup function, but it only returns the value of the cell and not the acutal hyperlink. Any thoughts on how to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks
I got it. I need to do that and to acuatlly put in the correct path.
"Shane Devenshire" wrote: Hi, try the HYPERLINK function: =HYPERLINK(A1) where A1 contains your hyperlink. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Chris B" wrote: I am creating a document that when you choose an option, it displays the hyperlink. I tried using the Vlookup function, but it only returns the value of the cell and not the acutal hyperlink. Any thoughts on how to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks | Excel Discussion (Misc queries) | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) |