Can I name a range a #

November 3, 2010 at 14:41:29
Specs: Windows XP
for instance, I want to name my range "1". I am using multiple drop down list, the 1st range is named "item description" which is a list of #1-14. I want to name 14 other ranges all #'s. the ranges will include a list of issues for each item description #. Everytime I try to name the range a #, it does not allow me. How do I match the #'s in my "item description" range with the next 14 ranges which need to be #'s I think??

See More: Can I name a range a #

Report •

November 3, 2010 at 19:50:45
As you have found, you can't use a number as a Range Name.

You can however, still use numbers in your primary Drop Down to populate your Dependent Drop Downs.

I am assuming that you plan to use the standard method of creating Dependent Drop Down, specifically Named Ranges and the INDIRECT function.

Let's say your primary Drop Down is in A1.

Name your Dependent ranges List1, List2, ... List14

Then, for the Dependent Drop Down use =INDIRECT("List" & A1)

Report •
Related Solutions

Ask Question