Defined Names containing numbers

[Roberg04]

Hello,

I am hoping someone can help,

I am building up layered dependant dropdowns which reference lists where the items contain numbers. The problem begins on the third level where the option chosen in the second level contains a number at the start which is key to the listing. Is there a way in which I can retain the number in the defined name to allow the 3rd level to control the options dependant on the previous value? Any help would be appreciated.

 

[jkpieterse]

Have a look at this example file: Dozens of Free Excel Downloads For You