Source in Data Validation to long

Danton

New Member
Joined
Jan 24, 2017
Messages
2
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!
 

Some videos you may like

Excel Facts

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

Watch MrExcel Video

Forum statistics

Threads
1,108,675
Messages
5,524,220
Members
409,565
Latest member
Suilenroc

This Week's Hot Topics

Top