populating fields automatically.

[AndyGray]

Hi guys. I'm trying to generate a CSV which with a variable product formation and need to auto populate a field....


Table below shows how my layout works, I need to read collumn A and if variation is followed by variable, then collumn C needs to be populated with collumn B.
If variation changes to Variable (next product) it needs to leave row C blank for the row saying variable and then copy tow B into row C for the next one down?

not sure how to explain that better, but hopefully the table will be of help.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Type
[/TD]
[TD]Sku
[/TD]
[TD]Parent
[/TD]
[/TR]
[TR]
[TD]variable
[/TD]
[TD]SKUAlphabet
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]variation
[/TD]
[TD]ABC
[/TD]
[TD]Skualphabet
[/TD]
[/TR]
[TR]
[TD]variation
[/TD]
[TD]DEF
[/TD]
[TD]Skualphabet
[/TD]
[/TR]
[TR]
[TD]variation
[/TD]
[TD]GHI
[/TD]
[TD]Skualphabet
[/TD]
[/TR]
[TR]
[TD]variable
[/TD]
[TD]SKUNumber
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]variation
[/TD]
[TD]1234
[/TD]
[TD]Skunumber
[/TD]
[/TR]
[TR]
[TD]variation
[/TD]
[TD]5678
[/TD]
[TD]Skunumber
[/TD]
[/TR]
</tbody>[/TABLE]

 

[hennahairgel]

Cell C2:
=IF(A2="variable","",IF(C1="",B1,C1))

copy down

 

[AndyGray]

Thanks, i think i'd been over thinking this, but now i've seen a simple if statement configured correctly It's much easier than i expected it to be.

Many thanks.