Forum Discussion
707lineman
Jun 29, 2025Copper Contributor
Named Range help
I need some help with my forumlas as I can't get them to work correctly So on MasterList sheet I have my data which i constantly add to. First Named Range across the top From A1-N1 Next Named R...
HansVogelaar
Jun 30, 2025MVP
Use underscores _ in the name of the named range, for example CLR_Lands (hyphens - aren't allowed).
Let's say you have a drop-down in A2 with a list that contains values such as CLR Lands.
In a cell next to it, you can use
=INDIRECT(SUBSTITUTE(A2, " ", "_"))
as source for data validation of type List.