Spreadsheet: 472244d1469511159-formula-vlookup-to-calculate-running-total-of-master-inventory-sheet-final-inventory-2
Sheet: Promo Inventory

 |  | INVENTORY
ITEM NAME | [NAME] | Qty per Box | Number of Boxes | Total | Notes
Air Freshner, Car | Scent: Citrus Blossom | 50 | 1
Air Pressure Gauge | Red | 50 | 1
Bag | Green, Black, Mesh | 200 | 1
Bag | Red, Black, Mesh | 25 | 1
Bag | Green, Black | 200 | 1
Bag | Red, White, Blue | 100 | 1
Bag, Drawstring | Orange, Grey | 200 | 11
Bag, Drawstring | Red | 300 | 5
Bag, Drawstring-Earth Day | Bright Green | 300 | 1 |  | Earth Day
Bag, Drawstring-EV | Orange, Grey | 200 | 4 |  | EV
Bag, Grocery | Grey | 100 | 1 |  | Rebates
Bag, Grocery | Black | 100 | 12
Bag, Grocery-Insulated | Red | 25 | 12 |  | Rebates
Bag, Grocery-Insulated | Lime | 25 | 4 |  | LED
Bag, Grocery-Insulated | Black | 25 | 10 |  | Home Performance
Bag, Gromets | Green, Black | 200 | 6
Bag, Insulated | Grey | 30 | 1
Bag, [NAME] | Green, White, Black | 200 | 7
Bag, [NAME] | Orange, Black | 200 | 3
Bag, [NAME] | Red, Black, Grey | 100 | 1
Bag, Paper/Gift | Orange | 150 | 1
Bag, Soccer | Black, White | 125 | 1
Bag, Woven | Khaki | 50 | 1
Ball, Beach | Multi | 200 | 2
Ball, Beach | Orange, Silver | 0 | 0
[NAME], Collapasable | Red, White | 40 | 1
Beads | Orange | 150 | 3
Bottle, Foil, Pop Up Top | Silver | 50 | 1
Bottle, Little | Light Green | 80 | 11
Bottle, Plastic, [NAME] | Orange | 500 | 3
Bottle, Sports | Red | 130 | 20
Car Shade | Orange | 20 | 1
Chapstick | White | 150 | 1
Charger, Car | Blue | 60 | 1
Clapper, Hand | Purple, White | 200 | 2
Clip | Red, White | 300 | 2
Clip | Orange | 50 | 1
Coloring Book |  | 125 | 11
Coloring Book, Disney | Princess | 24 | 17
Coloring Book, Disney | Monsters, Inc. | 36 | 9
Cup Sleeve | Red | 500 | 1
Cup Sleeve | Black | 100 | 1
Cup, Metal | Orange | 15 | 1
Cup, Plastic with Straw | Clear | 15 | 2
Cup, Plastic with Straw | Orange | 24 | 3
Ear Plugs |  | 500 | 1
Fan, Battery, LED Message |  | 48 | 9
Fan/Mister, Deluxe | Red | 30 | 1
First Aid Kit | Orange, White | 250 | 7
Flashlight w/Batteries | Grey | 100 | 1
[NAME] |  | 25 | 1
iPad Holder | Black | 45 | 1
Keychain, Hard Hat with Light | White | 300 | 1
Keychain, LED Light | Silver, Black | 250 | 1
Light Stick, Foam | White | 15 | 1
Marker | Black, Yellow, Orange, Green, Purple, Red | 150 | 6
Nightlight, LED | White | 200 | 7
Notebook, Recycled |  | 100 | 1
Pen | Silver, Lime Green | 100 | 1
Pen | Orange, White | 50 | 1
Pen, Light Up | Red | 70 | 12
Pen, Light Up | Green | 70 | 5
Pen, Recycled | Wood | 55 | 1
Pen, Recycled | Orange | 500 | 1
Pen, [NAME] | Green | 1000 | 2
Pencils, Mood | Multi | 250 | 8
Ponchos
Portfolio, Leather | Black | 15 | 2
Power Bank | Black | 75 | 1
[NAME] | Green | 200 | 2
[NAME] | Red | 200 | 1
Stressball | Red | 200 | 2
Sunglasses | Green | 300 | 2
Sunglasses | Orange | 300 | 1
Sunglasses, [NAME] | Yellow | 300 | 1
Sunglasses, [NAME] | Red | 300 | 1
Sunglasses, [NAME] | Pink | 300 | 1
Sunglasses, [NAME] | Purple | 300 | 1
Sunscreen, Foil Packet | White | 40 | 1
Sunscreen, Tube w/Chain | White | 75 | 1
Thermometer, Solar | Green | 75 | 1
[NAME] | Black, Grey | 10 | 1
Vase, Flat | Orange | 500 | 1
Wallet | Black | 125 | 1
Wallet, [NAME] | Red | 12 | 28
Wet Wipes | White | 6 | 1