Spreadsheet: 128866d1321312883-vlookups-with-multiple-conditions-copy-of-tracker-template
Sheet: Summary

2012 Tracker
All Other
POWDERS
 |  |  | GROSS SALES
Chocolate Powder 1 |  |  | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL
 | 2012 Actuals |  | 1524.117 | 0 | 0 | 0 | 1524.117 | 0 | 0 | 0 | 1524.117 | 0 | 0 | 0 | 4606.351 | 34
 | 2012 Plan |  | 0 | 861.59328 | 0 | 0 | 0 | 861.59328 | 0 | 0 | 0 | 861.59328 | 0 | 0 | 2618.77984 | 34
 | 2012 LBE |  | 0 | 0 | 1300.38078 | 0 | 0 | 0 | 1300.38078 | 0 | 0 | 0 | 1300.38078 | 0 | 3935.14234 | 34
 | 2012 S&OP |  | 0 | 0 | 0 | 1799.59074 | 0 | 0 | 0 | 1799.59074 | 0 | 0 | 0 | 1799.59074 | 5432.77222 | 34
Chocolate Powder 2
 | 2012 Actuals |  | 1528.55442 | 0 | 0 | 0 | 1528.55442 | 0 | 0 | 0 | 1528.55442 | 0 | 0 | 0 | 4585.663259999999
 | 2012 Plan |  | 0 | 1308.82728 | 0 | 0 | 0 | 1308.82728 | 0 | 0 | 0 | 1308.82728 | 0 | 0 | 3926.48184
 | 2012 LBE |  | 0 | 0 | 2181.20397 | 0 | 0 | 0 | 2181.20397 | 0 | 0 | 0 | 2181.20397 | 0 | 6543.61191
 | 2012 S&OP |  | 0 | 0 | 0 | 1159.25613 | 0 | 0 | 0 | 1159.25613 | 0 | 0 | 0 | 1159.25613 | 3477.76839
Chocolate Powder 3
 | 2012 Actuals |  | 1407.40533 | 0 | 0 | 0 | 1407.40533 | 0 | 0 | 0 | 1407.40533 | 0 | 0 | 0 | 4222.21599
 | 2012 Plan |  | 0 | 1331.8965 | 0 | 0 | 0 | 1331.8965 | 0 | 0 | 0 | 1331.8965 | 0 | 0 | 3995.6895
 | 2012 LBE |  | 0 | 0 | 1313.77611 | 0 | 0 | 0 | 1313.77611 | 0 | 0 | 0 | 1313.77611 | 0 | 3941.32833
 | 2012 S&OP |  | 0 | 0 | 0 | 2235.37419 | 0 | 0 | 0 | 2235.37419 | 0 | 0 | 0 | 2235.37419 | 6706.12257
Chocolate Powder 4
 | 2012 Actuals |  | 575.82747 | 0 | 0 | 0 | 575.82747 | 0 | 0 | 0 | 575.82747 | 0 | 0 | 0 | 1727.48241
 | 2012 Plan |  | 0 | 1217.53242 | 0 | 0 | 0 | 1217.53242 | 0 | 0 | 0 | 1217.53242 | 0 | 0 | 3652.59726
 | 2012 LBE |  | 0 | 0 | 1581.58419 | 0 | 0 | 0 | 1581.58419 | 0 | 0 | 0 | 1581.58419 | 0 | 4744.75257
 | 2012 S&OP |  | 0 | 0 | 0 | 3539.894670000001 | 0 | 0 | 0 | 3539.894670000001 | 0 | 0 | 0 | 3539.894670000001 | 10619.68401
BARS
Chocolate Bar 1 |  |  | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 34
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 34
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 34
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 34
Chocolate Bar 2
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Chocolate Bar 3
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Chocolate Bar 4
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Chocolate Bar 5
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0