if repititions help

[Guest]

Hi all,

Ihave cell G2 that requires a number entered to reflect the repititions of the task below.

c8 AB
c9 B
c10 BA
c11 A
c12 A
c13
c14
c15
c16
c17
c18

c8:c12 auto generated thru a lookup table. What I would like to do in c13 is =if(G2 = 2,c8,"") c14 =if(G2=2,c9,"")etc to c17.
In C18 if G2 =3,c13,"")etc, this returns"" as false applies to c13. how do I populate this down thru the column.

Thanks

Alby

 

[Andy B]

Hi

By using absolute and relative references, try something like this in C13:
=IF($G$2=2,C8,"")

You can then fill down and the reference to G2 will remain the same for each
entry.

--
Andy.

Hi all,

Ihave cell G2 that requires a number entered to reflect the repititions of the task below.

c8 AB
c9 B
c10 BA
c11 A
c12 A
c13
c14
c15
c16
c17
c18

c8:c12 auto generated thru a lookup table. What I would like to do in c13

is =if(G2 = 2,c8,"") c14 =if(G2=2,c9,"")etc to c17.

In C18 if G2 =3,c13,"")etc, this returns"" as false applies to c13. how do

I populate this down thru the column.

 

[Guest]

Thanks Andy, but what if G2 =3 , 4, 5or 6 etc

c13 will return "" if G2 is anything else but

c18 needs to return =c8 if g2=
c22 needs to return =c8 if g2=4, but c18 needs to be populated als
c27 needs to return =c8 if g2=5 but c22 needs to be populated als
c32 needs to return =c8 if g2=6 but c27 needs to be populated als
c37 needs to return =c8 if g2=7 but c32 needs to be populated also
Alby

 

[Andy B]

Ah. Suddenly this has become a lot more complex!! Initially it looked to me
like you just wanted to fill down, keeping the G2 reference static. In your
first post there was no mention of G2 equalling 7, or of the formula
changing further down the column, or the 'populated too' bit!!

You'd better lay down the criteria you want and where.