Offset - Example Populate Rows Vertically based on another column

[alex0182828]

I cant really explain this well so here is an example.


I need a formula to populate Column B. Any ideas would be super

 

[shift-del]

Hello Alex

[COLOR=#222222]=IF[/COLOR][COLOR=#0000dd](A2="parent","",LOOKUP[/COLOR][COLOR=#222222](42,1/[/COLOR][COLOR=#0000dd](A$2:A2="parent")[/COLOR][COLOR=#222222],D$2[COLOR=#222222]:[/COLOR]D2)[/COLOR][COLOR=#0000dd])[/COLOR]

 

[alex0182828]

Thanks Shift Del your a Champ.

Though i am not exactly sure how it works

Thanks. A