Forum Discussion
Steven2285
Jul 31, 2023Copper Contributor
Being able to use links from from another sheet in a dropdown generated from Data Validation.
I want to create a dropdown with a list of links from a range on a separate sheet. I can create the dropdown alright, but the links are unusable from the dropdown list. How can I make it to where the links in the dropdown are usable?
Most probably Start Dates are texts which only looks like dates, not dates (which are actually numbers). The rest depends on which is default date format on your machine.
As variant you may transform texts to dates with Data->Text to Columns selecting MDY on third step.
Or
=TEXT( DATE(2021, LEFT([@[Start Date]],2), 1), "mmm")
2 Replies
Sort By
- mtarlerSilver ContributorIf I understand correctly you have a links like
https://google.com
on 1 sheet and a drop down on another but when the user uses that drop down they can no longer actually click that link and go to that website? And yes links will not pass to referenced cells be it any cell formula like LOOKUP(...) or using the Data Validation. But you can add a cell to the right of that drop down and use
=HYPERLINK(A1, "Go To Link ->")
where A1 is that drop down cell.
If that cell isn't the web address but a friendly name then I suggest you split the original source into a column of friendly names and link addresses and then do something like:
=HYPERLINK(XLOOKUP(A1,LinkTable[FriendlyName],LinkTable[LinkAddress]),"Go To Link ->")- Steven2285Copper ContributorThank you very much! I appreciate your help.