Calculate where cell value exceeds cell in column B

[cmb80]

Hi all, in my attachment I have 4 items. In column B I have the current stock level. In columns C:O I have the stock needed (cumulative).

Highlighted in yellow is where the stock runs out (the number is higher than the number in B).

What I want for each part as in column P - is the week where this happens (the number is greater than in B)

I hope someone can help

[leonieke1960]

Something like this?

Example_1.xlsm

[Glenn Kennedy]

Alternatively, in P3 and copy down...

=INDEX($C$2:$O$2,MATCH(B3,C3:O3,1)+1)

[cmb80]

Thanks, works a treat