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)))))))))))))))))
Thank you in advance!
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)))))))))))))))))
Thank you in advance!
