Find Date that an Order qty is fulfilled

[GorD]

I feel this should be easy, but having a bit of a mental block this morning

I have weeks in coulmns and associated build qtys for those weeks - say 10 per week

I also have sales orders which may be a qty of 50 - I want to find when the qty of 50 is built and then return the date or weeknum when this happens

The next order may be for 60 so I would need to find when 110 units are scheduled to be built


Many thanks

 

[GorD]

Maybe not as easy as I first thought

so far using

=INDEX('Cust Schedule'!$H$2:$BE$2,MATCH(TRUE,INDEX('Cust Schedule'!$H$62:$BE$62>=$N15,0),0))

which is partially working