Spreadsheet: 128828d1321299203-vlookups-with-multiple-conditions-tracker-template
Sheet: Data

Retailer | Cycle | Period | Product | Gross Sales
All Other | 2012 Actuals | Jan | Chocolate Powder 1 | 508.039
All Other | 2012 Actuals | Jan | Chocolate Powder 2 | 509.51814
All Other | 2012 Actuals | Jan | Chocolate Powder 3 | 469.1351099999999
All Other | 2012 Actuals | Jan | Chocolate Powder 4 | 191.94249
All Other | 2012 Plan | Feb | Chocolate Powder 1 | 287.19776
All Other | 2012 Plan | Feb | Chocolate Powder 2 | 436.27576
All Other | 2012 Plan | Feb | Chocolate Powder 3 | 443.9655
All Other | 2012 Plan | Feb | Chocolate Powder 4 | 405.8441399999999
All Other | 2012 LBE | Mar | Chocolate Powder 1 | 433.4602599999999
All Other | 2012 LBE | Mar | Chocolate Powder 2 | 727.06799
All Other | 2012 LBE | Mar | Chocolate Powder 3 | 437.92537
All Other | 2012 LBE | Mar | Chocolate Powder 4 | 527.1947299999999
All Other | 2012 S&OP | Apr | Chocolate Powder 1 | 599.86358
All Other | 2012 S&OP | Apr | Chocolate Powder 2 | 386.41871
All Other | 2012 S&OP | Apr | Chocolate Powder 3 | 745.12473
All Other | 2012 S&OP | Apr | Chocolate Powder 4 | 1179.96489
All Other | 2012 Actuals | May | Chocolate Powder 1 | 508.039
All Other | 2012 Actuals | May | Chocolate Powder 2 | 509.51814
All Other | 2012 Actuals | May | Chocolate Powder 3 | 469.1351099999999
All Other | 2012 Actuals | May | Chocolate Powder 4 | 191.94249
All Other | 2012 Plan | Jun | Chocolate Powder 1 | 287.19776
All Other | 2012 Plan | Jun | Chocolate Powder 2 | 436.27576
All Other | 2012 Plan | Jun | Chocolate Powder 3 | 443.9655
All Other | 2012 Plan | Jun | Chocolate Powder 4 | 405.8441399999999
All Other | 2012 LBE | Jul | Chocolate Powder 1 | 433.4602599999999
All Other | 2012 LBE | Jul | Chocolate Powder 2 | 727.06799
All Other | 2012 LBE | Jul | Chocolate Powder 3 | 437.92537
All Other | 2012 LBE | Jul | Chocolate Powder 4 | 527.1947299999999
All Other | 2012 S&OP | Aug | Chocolate Powder 1 | 599.86358
All Other | 2012 S&OP | Aug | Chocolate Powder 2 | 386.41871
All Other | 2012 S&OP | Aug | Chocolate Powder 3 | 745.12473
All Other | 2012 S&OP | Aug | Chocolate Powder 4 | 1179.96489
All Other | 2012 Actuals | Sep | Chocolate Powder 1 | 508.039
All Other | 2012 Actuals | Sep | Chocolate Powder 2 | 509.51814
All Other | 2012 Actuals | Sep | Chocolate Powder 3 | 469.1351099999999
All Other | 2012 Actuals | Sep | Chocolate Powder 4 | 191.94249
All Other | 2012 Plan | Oct | Chocolate Powder 1 | 287.19776
All Other | 2012 Plan | Oct | Chocolate Powder 2 | 436.27576
All Other | 2012 Plan | Oct | Chocolate Powder 3 | 443.9655
All Other | 2012 Plan | Oct | Chocolate Powder 4 | 405.8441399999999
All Other | 2012 LBE | Nov | Chocolate Powder 1 | 433.4602599999999
All Other | 2012 LBE | Nov | Chocolate Powder 2 | 727.06799
All Other | 2012 LBE | Nov | Chocolate Powder 3 | 437.92537
All Other | 2012 LBE | Nov | Chocolate Powder 4 | 527.1947299999999
All Other | 2012 S&OP | Dec | Chocolate Powder 1 | 599.86358
All Other | 2012 S&OP | Dec | Chocolate Powder 2 | 386.41871
All Other | 2012 S&OP | Dec | Chocolate Powder 3 | 745.12473
All Other | 2012 S&OP | Dec | Chocolate Powder 4 | 1179.96489
Retailer 1 | 2012 Actuals | Jan | Chocolate Powder 1 | 508.039
Retailer 1 | 2012 Actuals | Jan | Chocolate Powder 2 | 509.51814
Retailer 1 | 2012 Actuals | Jan | Chocolate Powder 3 | 469.1351099999999
Retailer 1 | 2012 Actuals | Jan | Chocolate Powder 4 | 191.94249
Retailer 1 | 2012 Plan | Feb | Chocolate Powder 1 | 287.19776
Retailer 1 | 2012 Plan | Feb | Chocolate Powder 2 | 436.27576
Retailer 1 | 2012 Plan | Feb | Chocolate Powder 3 | 443.9655
Retailer 1 | 2012 Plan | Feb | Chocolate Powder 4 | 405.8441399999999
Retailer 1 | 2012 LBE | Mar | Chocolate Powder 1 | 433.4602599999999
Retailer 1 | 2012 LBE | Mar | Chocolate Powder 2 | 727.06799
Retailer 1 | 2012 LBE | Mar | Chocolate Powder 3 | 437.92537
Retailer 1 | 2012 LBE | Mar | Chocolate Powder 4 | 527.1947299999999
Retailer 1 | 2012 S&OP | Apr | Chocolate Powder 1 | 599.86358
Retailer 1 | 2012 S&OP | Apr | Chocolate Powder 2 | 386.41871
Retailer 1 | 2012 S&OP | Apr | Chocolate Powder 3 | 745.12473
Retailer 1 | 2012 S&OP | Apr | Chocolate Powder 4 | 1179.96489
Retailer 1 | 2012 Actuals | May | Chocolate Powder 1 | 508.039
Retailer 1 | 2012 Actuals | May | Chocolate Powder 2 | 509.51814
Retailer 1 | 2012 Actuals | May | Chocolate Powder 3 | 469.1351099999999
Retailer 1 | 2012 Actuals | May | Chocolate Powder 4 | 191.94249
Retailer 1 | 2012 Plan | Jun | Chocolate Powder 1 | 287.19776
Retailer 1 | 2012 Plan | Jun | Chocolate Powder 2 | 436.27576
Retailer 1 | 2012 Plan | Jun | Chocolate Powder 3 | 443.9655
Retailer 1 | 2012 Plan | Jun | Chocolate Powder 4 | 405.8441399999999
Retailer 1 | 2012 LBE | Jul | Chocolate Powder 1 | 433.4602599999999
Retailer 1 | 2012 LBE | Jul | Chocolate Powder 2 | 727.06799
Retailer 1 | 2012 LBE | Jul | Chocolate Powder 3 | 437.92537
Retailer 1 | 2012 LBE | Jul | Chocolate Powder 4 | 527.1947299999999
Retailer 1 | 2012 S&OP | Aug | Chocolate Powder 1 | 599.86358
Retailer 1 | 2012 S&OP | Aug | Chocolate Powder 2 | 386.41871
Retailer 1 | 2012 S&OP | Aug | Chocolate Powder 3 | 745.12473
Retailer 1 | 2012 S&OP | Aug | Chocolate Powder 4 | 1179.96489
Retailer 1 | 2012 Actuals | Sep | Chocolate Powder 1 | 508.039
Retailer 1 | 2012 Actuals | Sep | Chocolate Powder 2 | 509.51814
Retailer 1 | 2012 Actuals | Sep | Chocolate Powder 3 | 469.1351099999999
Retailer 1 | 2012 Actuals | Sep | Chocolate Powder 4 | 191.94249
Retailer 1 | 2012 Plan | Oct | Chocolate Powder 1 | 287.19776
Retailer 1 | 2012 Plan | Oct | Chocolate Powder 2 | 436.27576
Retailer 1 | 2012 Plan | Oct | Chocolate Powder 3 | 443.9655
Retailer 1 | 2012 Plan | Oct | Chocolate Powder 4 | 405.8441399999999
Retailer 1 | 2012 LBE | Nov | Chocolate Powder 1 | 433.4602599999999
Retailer 1 | 2012 LBE | Nov | Chocolate Powder 2 | 727.06799
Retailer 1 | 2012 LBE | Nov | Chocolate Powder 3 | 437.92537
Retailer 1 | 2012 LBE | Nov | Chocolate Powder 4 | 527.1947299999999
Retailer 1 | 2012 S&OP | Dec | Chocolate Powder 1 | 599.86358
Retailer 1 | 2012 S&OP | Dec | Chocolate Powder 2 | 386.41871
Retailer 1 | 2012 S&OP | Dec | Chocolate Powder 3 | 745.12473
Retailer 1 | 2012 S&OP | Dec | Chocolate Powder 4 | 1179.96489
Retailer 2 | 2012 Actuals | Jan | Chocolate Powder 1 | 508.039
Retailer 2 | 2012 Actuals | Jan | Chocolate Powder 2 | 509.51814
Retailer 2 | 2012 Actuals | Jan | Chocolate Powder 3 | 469.1351099999999
Retailer 2 | 2012 Actuals | Jan | Chocolate Powder 4 | 191.94249
Retailer 2 | 2012 Plan | Feb | Chocolate Powder 1 | 287.19776
Retailer 2 | 2012 Plan | Feb | Chocolate Powder 2 | 436.27576
Retailer 2 | 2012 Plan | Feb | Chocolate Powder 3 | 443.9655
Retailer 2 | 2012 Plan | Feb | Chocolate Powder 4 | 405.8441399999999
Retailer 2 | 2012 LBE | Mar | Chocolate Powder 1 | 433.4602599999999
Retailer 2 | 2012 LBE | Mar | Chocolate Powder 2 | 727.06799
Retailer 2 | 2012 LBE | Mar | Chocolate Powder 3 | 437.92537
Retailer 2 | 2012 LBE | Mar | Chocolate Powder 4 | 527.1947299999999
Retailer 2 | 2012 S&OP | Apr | Chocolate Powder 1 | 599.86358
Retailer 2 | 2012 S&OP | Apr | Chocolate Powder 2 | 386.41871
Retailer 2 | 2012 S&OP | Apr | Chocolate Powder 3 | 745.12473
Retailer 2 | 2012 S&OP | Apr | Chocolate Powder 4 | 1179.96489
Retailer 2 | 2012 Actuals | May | Chocolate Powder 1 | 508.039
Retailer 2 | 2012 Actuals | May | Chocolate Powder 2 | 509.51814
Retailer 2 | 2012 Actuals | May | Chocolate Powder 3 | 469.1351099999999
Retailer 2 | 2012 Actuals | May | Chocolate Powder 4 | 191.94249
Retailer 2 | 2012 Plan | Jun | Chocolate Powder 1 | 287.19776
Retailer 2 | 2012 Plan | Jun | Chocolate Powder 2 | 436.27576
Retailer 2 | 2012 Plan | Jun | Chocolate Powder 3 | 443.9655
Retailer 2 | 2012 Plan | Jun | Chocolate Powder 4 | 405.8441399999999
Retailer 2 | 2012 LBE | Jul | Chocolate Powder 1 | 433.4602599999999
Retailer 2 | 2012 LBE | Jul | Chocolate Powder 2 | 727.06799
Retailer 2 | 2012 LBE | Jul | Chocolate Powder 3 | 437.92537
Retailer 2 | 2012 LBE | Jul | Chocolate Powder 4 | 527.1947299999999
Retailer 2 | 2012 S&OP | Aug | Chocolate Powder 1 | 599.86358
Retailer 2 | 2012 S&OP | Aug | Chocolate Powder 2 | 386.41871
Retailer 2 | 2012 S&OP | Aug | Chocolate Powder 3 | 745.12473
Retailer 2 | 2012 S&OP | Aug | Chocolate Powder 4 | 1179.96489
Retailer 2 | 2012 Actuals | Sep | Chocolate Powder 1 | 508.039
Retailer 2 | 2012 Actuals | Sep | Chocolate Powder 2 | 509.51814
Retailer 2 | 2012 Actuals | Sep | Chocolate Powder 3 | 469.1351099999999
Retailer 2 | 2012 Actuals | Sep | Chocolate Powder 4 | 191.94249
Retailer 2 | 2012 Plan | Oct | Chocolate Powder 1 | 287.19776
Retailer 2 | 2012 Plan | Oct | Chocolate Powder 2 | 436.27576
Retailer 2 | 2012 Plan | Oct | Chocolate Powder 3 | 443.9655
Retailer 2 | 2012 Plan | Oct | Chocolate Powder 4 | 405.8441399999999
Retailer 2 | 2012 LBE | Nov | Chocolate Powder 1 | 433.4602599999999
Retailer 2 | 2012 LBE | Nov | Chocolate Powder 2 | 727.06799
Retailer 2 | 2012 LBE | Nov | Chocolate Powder 3 | 437.92537
Retailer 2 | 2012 LBE | Nov | Chocolate Powder 4 | 527.1947299999999
Retailer 2 | 2012 S&OP | Dec | Chocolate Powder 1 | 599.86358
Retailer 2 | 2012 S&OP | Dec | Chocolate Powder 2 | 386.41871
Retailer 2 | 2012 S&OP | Dec | Chocolate Powder 3 | 745.12473
Retailer 2 | 2012 S&OP | Dec | Chocolate Powder 4 | 1179.96489