### [Solved] Stop one part of the formula from advancing

Posted:

**Sun Oct 13, 2019 6:12 am**Hi, again...

I'm now struggling with a slightly different part of the formula that I was using the other day.

=IF(B4="1A";Lots.E3;IF(B4="1B";Lots.E4;IF(B4="1C";Lots.E5;IF(B4=2;Lots.E6;IF(B4=3;Lots.E7;IF(B4=4;Lots.E8;""))))))&IF(B4=5;Lots.E9;IF(B4=6;Lots.E10;IF(B4=7;Lots.E11;IF(B4=8;Lots.E12;IF(B4=9;Lots.E13;IF(B4=10;Lots.E14;""))))))&IF(B4=11;Lots.E15;IF(B4=12;Lots.E16;IF(B4=13;Lots.E17;IF(B4=14;Lots.E18;IF(B4=15;Lots.E19;IF( B4=16;Lots.E20;""))))))&IF(B4="17A";Lots.E21;IF(B4="17B";Lots.E22;IF(B4="17C";Lots.E23;IF(B4=18;Lots.E24;""))))

basically I am filling out a table and I want it to fill out another table based on what I am entering (I'm probably using the wrong formula ) however I've been trying to "drag-copy" the formula so it populates the rest of the table... however I only want the B4 to change to B5 and so on, not the "Lots.E..."

I have very little experience in formulas like this but if I can get it going it will make my life so much easier.

I'm now struggling with a slightly different part of the formula that I was using the other day.

=IF(B4="1A";Lots.E3;IF(B4="1B";Lots.E4;IF(B4="1C";Lots.E5;IF(B4=2;Lots.E6;IF(B4=3;Lots.E7;IF(B4=4;Lots.E8;""))))))&IF(B4=5;Lots.E9;IF(B4=6;Lots.E10;IF(B4=7;Lots.E11;IF(B4=8;Lots.E12;IF(B4=9;Lots.E13;IF(B4=10;Lots.E14;""))))))&IF(B4=11;Lots.E15;IF(B4=12;Lots.E16;IF(B4=13;Lots.E17;IF(B4=14;Lots.E18;IF(B4=15;Lots.E19;IF( B4=16;Lots.E20;""))))))&IF(B4="17A";Lots.E21;IF(B4="17B";Lots.E22;IF(B4="17C";Lots.E23;IF(B4=18;Lots.E24;""))))

basically I am filling out a table and I want it to fill out another table based on what I am entering (I'm probably using the wrong formula ) however I've been trying to "drag-copy" the formula so it populates the rest of the table... however I only want the B4 to change to B5 and so on, not the "Lots.E..."

I have very little experience in formulas like this but if I can get it going it will make my life so much easier.