# Source in Data Validation to long

#### Danton

##### New Member
Hy all!
I have 25 dynamic lists and i need to make a cell with data validation that shows me a list according to the first cell value. I used Name Manager to create the lists (A-Y to shorten the length... C & R was not allowed so i used CC & RR), but the formula in Data Validation Source is to long (>255 characters).
Can you help me please with this problem?
=IF(A1=\$E\$1;A;IF(A1=\$F\$1;B;IF(A1=\$G\$1;CC;IF(A1=\$H\$1;D;IF(A1=\$I\$1;E;IF(A1=\$J\$1;F;IF(A1=\$K\$1;G;IF(A1=\$L\$1;H;IF(A1=\$M\$1;I;IF(A1=\$N\$1;J;IF(A1=\$O\$1;K;IF(A1=\$P\$1;L;IF(A1=\$Q\$1;M;IF(A1=\$R\$1;N;IF(A1=\$S\$1;O;IF(A1=\$T\$1;P;IF(A1=\$U\$1;Q;IF(A1=\$V\$1;RR;IF(A1=\$W\$1;S;IF(A1=\$X\$1;T;IF(A1=\$Y\$1;U;IF(A1=\$Z\$1;V;IF(A1=\$AA\$1;W;IF(A1=\$AB\$1;X;IF(A1=\$AC\$1;Y;0)))))))))))))))))

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Replies
3
Views
48
Replies
5
Views
67
Replies
9
Views
125
Replies
0
Views
50
Replies
1
Views
27