Ive recently taken a few cells and added a hyperlink in each to their own respective files. In a separate sheet I've used the vlookup function to pull those file locations from the previous cells described. The problem im experiencing is that the hyperlinks do not get carried over to the new sheet. I can still copy the file locations displayed in those vlookup cells and paste them into file explorer or the windows search and they will open just fine. But it would be even more convenient if the hyperlinks would get transferred over to the new sheet as well. I believe the issue im experiencing is because the cells and their contents i would like to show hyperlinks are always changing. So the hyperlink aspect of excel only allows you to define one location per cell and its based on that cell alone and not the verbiage stored inside. So when a hyperlink is defined in a cell it is set, and will not change unless you redefine it.
Essentially i have 5 cells that will list a file location based on what is searched. I would like those five cells to include the hyperlink location for the particular project files when that particular project is selected. All the pertinent information is stored on 1 sheet organized in a table. I then have a sheet with a search bar that will consolidate the information from the table to where its easier to unpack.
Is there any solutions to this problem i'm experiencing? Or is this something that is just fixed, based on limitations of excel itself?
Bookmarks