bgiovanni1!
New member
- Joined
- Dec 11, 2019
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365
So, I wish Excel or Google Sheets had the option of keeping links intact when you did a drop down list in data validation, but it doesn't. I decided the next best thing would be to have another column inserted next to the column with the drop down list, and get a formula that would auto-populate the column with the matching hyperlink if that item was picked from the drop-down. This is the spreadsheet I am working with:
Thanks in advance for any help!
Thanks in advance for any help!