Repeat Material Codes

Hi All

If C:C>0, i want my formula to enter the relevant material code in A:A, but i have multiple material codes, how do i make my formula notice the change in material and show the new material value...

Please see attached file

My Logic...

Once i have the material running along side the order, i will use a lookup to show load by time and current material shortages.

I hope this makes sense.

Thanks

Chris..