Spreadsheet: 713641d1610857350-need-formula-to-match-each-weeks-target-to-forward-volumes-restarting-each-week-210117-lead-time-problem
Sheet: LEAD TIMES

[NAME] | Week | SKU ROW 4 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 5 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 6 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 7 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 8 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 9 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 10 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 11 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 12 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 13 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 14 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 15 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 16 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 17 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order
 | 20-28 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-29 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-30 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-31 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-32 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-33 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-34 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-35 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Week is more than weeks remaining, so [NAME] needs to show "PO".
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Tried adjusting the [NAME] as show below, but turned PRIOR weeks "PO" because they count the 10000 Sales in the future week calculations?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(IF(M5,MATCH(M5,J5+MMULT(--(ROW(K5:K$12)>=TRANSPOSE(ROW(K5:K$12))),K5:K$12)),"")>COUNT(B6:$B12),"PO"
 |  |  |  |  |  |  |  |  |  |  |  |  | Row 5: