Forum Discussion
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...
A named range can NOT have a space in it. If you want the user to select from a list of 'names' and those names may have one or more spaces in them then I suggest you do a SUBSTITUTE( X, " ", "_") on that selection and then make sure you use and underscore ( _ ) character in your names in place of the spaces (or pick whatever character you wish)
so you formula would be like:
=INDIRECT(SUBSTITUTE( A1, " ", "_"))
and of course I would consider just avoiding the whole INDIRECT() if possible. for example if the names are columns in the table then you can have a lookup table relating name to column number or use XMATCH for that name in the column header.