Named Ranges

Im am trying to create a chart which has many drop down boxes. However 90% of my chart is purely numerical which is were i am struggling. i no you can not name a range with starting with a number but is there any way around this.

basically my first 2 drop down list are based on term and price and the price drop down list is based on the outcome of the first drop down list.

I.e

my terms in month are 1,3,12,18,24 and when selected should bring up an option of 4 different prices. Id rather not have to change them to the worded equivalent ie one,three etc as it does look as good.

so... is there away that i can maybe name the range as the worded version but have my drop down list only show the numbered version??

cheers.

If you are selecting numbers 1, 3, 12 in A1 cell and validation list is required in B1 cell. Range names are Range1, Range2 ,Range3.
In Validation - List enter the following Formula.

=INDIRECT(IF(A1=1,"Range1",(IF(A1=3,"Range2","Range3"))))

i may be a lil bit thick or i t may be early morning but could you explain it in terms of my diagram below. B1:F1 is the data for the first drop down box and abvioulsy anything below those in B1:F1 is what i would like to appear in the second list

A B C D E F
1 term 1 3 12 18 24
2 10 11 10 12 10
3 13 14 15 13 13
4 15 16 16 15 15
5 18 19 17 17 16

cheers

Pl see the attached file.

perfect thanks so much for your help

Thanks . Pl mark the thread Solved.