I have a collection of all the different part numbers for different versions of a single part, and each of them is hyperlinked to their specific different drawing in pdf form. I would like to put them into a Data Validation list so that someone can select which version they would like, however the hyperlinks do not "go with" the cells when they are selected (only does plain text). How can I get the hyperlinks to carry over for each different item in the list?
I made a small table with each part number and the corresponding link to the file server location in plain text. Then I can have a dropdown that selects any of the parts, and a second cell that uses that selection to generate the correct hyperlink from the table. The issue is this solution requires 2 different cells, where I only have room for one. Is there a way to get my dropdown list to also change hyperlinks in-cell?