Forum Discussion
Getting a Hyperlink to work through lookup / index
I have made it work to where it will jump to the location of the original hyperlink. What i am trying to accomplish is to have the hyperlink on "sheet 2" while on "sheet 1" you have the hyperlink displayed as a lookup/index based off of your original selection and opens the file itself, not directing you to "sheet 2"
Attached is a smaller version of the file i'm working with. the first page is the user interface. I want people to be able to search up the items on sheet 2 and click on the hyperlink to open it on page one (from the link on page 2).
- You have a hyperlink in Sheet1 that jumps to another hyperlink in Sheet2. Do you want the hyperlink in Sheet2 to jump back to the hyperlink in Sheet1? Please clarify.
Twifoo I want to be able to lookup the hyperlink on page 1 from page 2 and have it work. If you use index/lookup command to bring up the cell on page 1 where the hyperlink is from page 2 i want to be able to click it and have it open up, not jump to page 2. I cannot get the hyperlink to work across sheets. I want to have a searchable hyperlink database on sheet 1 with all of the hyperlinks attached on sheet 2.