Spreadsheet: 47654d1246796129-array-formula-problem-sample
Sheet: Consumables Codes

 | Corby Consumables List & QTY AVALIABLE IN STOCK
iForce Code | Supplier code | SAP code | Description | Dimensions | Description   Dimensions | Supplier | volume (litres) | QTY IN STOCK
BOX1 | SW09 |  | Single Wall | 305x229x112 | Single Wall   305x229x112 | network | 7.7 | 10
[NAME] | SW12 |  | Single Wall | 305x229x229 | Single Wall   305x229x229 | network | 16 | 0
BOX3 | SW20 |  | Single Wall | 457x305x305 | Single Wall   457x305x305 | network | 42.5 | 0
BOX4 | SW27 |  | Single Wall | 600x400x335** | Single Wall   600x400x335** | network | 80 | 0
iForce Code | Supplier code | SAP code | Description | Dimensions | Description   Dimensions | Supplier | volume (litres) | QTY IN STOCK
BOX5 | DW26MD |  | Double Wall | 457x305x305 | Double Wall   457x305x305 | network | 42.5 | 0
BOX6 | CSPI017301818 |  | Double Wall | 610x457x457 | Double Wall   610x457x457 | network | 127 | 0
iForce Code | Supplier code | SAP code | Description | Dimensions | Description   Dimensions | Supplier | volume (litres) | QTY IN STOCK
BAG1 | 1 | 24959 | Online self seal - small mailing bag | [NAME] (55MU) | Online self seal - small mailing bag   525x600x50 Lip (55MU) | Europackaging |  | 30020
BAG2 |  | 24960 | Online self seal - medium mailing bag | [NAME] (55MU) | Online self seal - medium mailing bag   600x700x50 Lip (55MU) | Europackaging |  | 0
BAG3 |  | 24961 | Online self seal - large mailing bag | 830x1050x50 Lip (55MU) | Online self seal - large mailing bag   830x1050x50 Lip (55MU) | Europackaging |  | 0
JIFFY1 |  | 24962 | Online padded Jiffy D1 | 255x200x50 Lip | Online padded Jiffy D1   255x200x50 Lip | Europackaging |  | 0
JIFFY2 |  | 24963 | Online padded Jiffy F3 | 340x240x50 Lip | Online padded Jiffy F3   340x240x50 Lip | Europackaging |  | 0
JIFFY3 |  | 24964 | Online padded Jiffy H5 | 370x290x50 Lip | Online padded Jiffy H5   370x290x50 Lip | Europackaging |  | 0
LFT1 |  | 24965 | Online Layflat Tubing 460mm x 263m | 460mm GAUGE 90MU | Online Layflat Tubing 460mm x 263m   460mm GAUGE 90MU | Europackaging |  | 0
LFT2 |  | 24966 | Online Layflat Tubing 1120mm x 123m | 1120mm GAUGE 90MU | Online Layflat Tubing 1120mm x 123m   1120mm GAUGE 90MU | Europackaging |  | 0
 |  |  | Rework bag 1 |  | Rework bag 1 | tbc |  | 0
 |  |  | Rework bag 2 |  | Rework bag 2 | tbc |  | 0
iForce Code | Supplier code | SAP code | Description | Dimensions | Description   Dimensions | Supplier | volume (litres) | QTY IN STOCK
 | TBC |  | Air Cushion film (recycled) |  | Air Cushion film (recycled) | FROMM |  | 0
 | PPC150HM |  | Clear Tape | 48mm x 66m | Clear Tape   48mm x 66m | network |  | 0
 |  | 24967 | TSNT printed tape | 48mm x 66m | TSNT printed tape   48mm x 66m | Europackaging |  | 0
 | CTB29048 |  | Cable tie | 290x4.8mm | Cable tie   290x4.8mm | network |  | 0
 | BL52525 |  | Black stretch wrap | 500x300x25mu | Black stretch wrap   500x300x25mu | network |  | 0
 | SB2053 |  | Clear stretch wrap | 500x300x20mu | Clear stretch wrap   500x300x20mu | network |  | 0
 |  | 7836 | Document wallet - A5 printed |  | Document wallet - A5 printed | Europackaging |  | 0
 |  |  | HP 4000 series printer toner |  | HP 4000 series printer toner | Laserlife |  | 0
iForce Code | Supplier code | SAP code | Description | Dimensions | Description   Dimensions | Supplier | volume (litres) | QTY IN STOCK
 | CSPI014BOX |  | Returns pallet box | 1180x980x838 | Returns pallet box   1180x980x838 | network |  | 0
 | CSPI014LID |  | Returns pallet box - lid | 1195x995x100 | Returns pallet box - lid   1195x995x100 | network |  | 0
 | LB2750 |  | Large bubble wrap - double roll | 750mm x2 | Large bubble wrap - double roll   750mm x2 | network |  | 0
 | PPS1215PR |  | Strapping | 12mm x 1500m | Strapping    12mm x 1500m | network |  | 0
 | PPSS12 |  | Strapping seals | 12[NAME] size | Strapping seals   12[NAME] size | network |  | 0
iForce Code | Supplier code | SAP code | Description | Dimensions | Description   Dimensions | Supplier | volume (litres) | QTY IN STOCK
 |  |  | Pick n stick labels pale yellow 12's | 12 per page A4 | Pick n stick labels pale yellow 12's   12 per page A4 | Forms plus |  | 0
 |  |  | Pick n stick labels bright yellow 12's | 12 per page A4 | Pick n stick labels bright yellow 12's   12 per page A4 | Forms plus |  | 0
 |  |  | Pick n stick labels white 12's | 12 per page A4 | Pick n stick labels white 12's   12 per page A4 | Forms plus |  | 0
 |  |  | Goods in / returns labels | 100x76mm | Goods in / returns labels   100x76mm | Earlsmere |  | 0
 |  |  | Goods in / rework labels | 101x26mm | Goods in / rework labels   101x26mm | Earlsmere |  | 0
 |  |  | Despatch labels (plain) | 140x100mm | Despatch labels (plain)   140x100mm | Forms plus |  | 0
 |  |  | Rack labels 16 per page | 16 per page A4 | Rack labels 16 per page   16 per page A4 | Office Depot |  | 0
 |  |  | Rack labels 6 per page | 6 per page A4 | Rack labels 6 per page   6 per page A4 | Office Depot |  | 0
 |  |  | A4 [NAME] paper - plain white | A4 | A4 [NAME] paper - plain white   A4 | Office Depot |  | 0
 |  |  | Despatch pro-forma paperwork |  | Despatch pro-forma paperwork | tbc |  | 0