Home |
Search |
Today's Posts |
#1
|
|||
|
|||
carrying a hyper link when using the vlookup function
I have a hyperlink on a spreadsheet. When I use the vlookup function
on another spreadsheet it carries over the text from the other spreadsheet but not the hyperlink...meaning that if I click on the text on the new page it will not take me to another spreadsheet as it would when I click on the original hyperlink. My question is how can I use the vlookup function to transfer the text over but also the hyperlink. Thanks, Mike- |
#2
|
|||
|
|||
=vlookup() returns the value in the cell.
If the value in the cell is the same as the hyperlink: =hyperlink(vlookup(...)) may work for you. mike wrote: I have a hyperlink on a spreadsheet. When I use the vlookup function on another spreadsheet it carries over the text from the other spreadsheet but not the hyperlink...meaning that if I click on the text on the new page it will not take me to another spreadsheet as it would when I click on the original hyperlink. My question is how can I use the vlookup function to transfer the text over but also the hyperlink. Thanks, Mike- -- Dave Peterson |
#3
|
|||
|
|||
Hi Dave,
I tried that but it told me it cannot find the address. I went back to the other spread sheet which had the hyperlink and it worked just fine. What should I do? Dave Peterson wrote in message ... =vlookup() returns the value in the cell. If the value in the cell is the same as the hyperlink: =hyperlink(vlookup(...)) may work for you. mike wrote: I have a hyperlink on a spreadsheet. When I use the vlookup function on another spreadsheet it carries over the text from the other spreadsheet but not the hyperlink...meaning that if I click on the text on the new page it will not take me to another spreadsheet as it would when I click on the original hyperlink. My question is how can I use the vlookup function to transfer the text over but also the hyperlink. Thanks, Mike- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I see an example of the vlookup function in excel? | Excel Worksheet Functions | |||
Regarding IF function or vLOOKUP function | Excel Worksheet Functions | |||
VLOOKUP and AND function | Excel Worksheet Functions | |||
vlookup function in excel referencing an access table | Excel Worksheet Functions | |||
vlookup and IF function | Excel Worksheet Functions |