Forum Discussion
Getting a Hyperlink to work through lookup / index
Hey how is everyone doin today. New here been trying to figure out how to get this to work but I have no luck. I am attempting to utilize an automated lookup table to display information as long as a...
Please refer to my reply here for an idea of how you may construct your formula:
https://techcommunity.microsoft.com/t5/Excel/Lookup-data-from-sheet-link-to-that-data-on-click/m-p/389858#M27926
https://techcommunity.microsoft.com/t5/Excel/Lookup-data-from-sheet-link-to-that-data-on-click/m-p/389858#M27926
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"
- You need to attach your excel sample file so I can test how to make the hyperlink formula work for you.
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).
