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.

Type	Sku	Parent
variable	SKUAlphabet
variation	ABC	Skualphabet
variation	DEF	Skualphabet
variation	GHI	Skualphabet
variable	SKUNumber
variation	1234	Skunumber
variation	5678	Skunumber

<tbody>
</tbody>

 

[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.