Spreadsheet: 270494d1381502323-using-lookup-to-return-an-answer-from-a-table-ftlookup
Sheet: Stax Week   Invoice

INVOICE
Invoice To: |  |  |  | Invoice Number: |  | 3310002
 |  |  |  | Invoice Date: |  | 2013-10-04 00:00:00
 |  | Contract Charges W-Ending |  | 2013-10-04 00:00:00
 | Date | Description |  |  |  |  |  | Amount (£)
 |  | Goods Receipt
 |  | GRN | Cartons | Pallets | Products
 | 2013-10-01 00:00:00 | 10768-69 | 594 | 20 | 3 |  |  | 107.22
 |  |  | 594 | 20 | 3 |  |  | 107.22
 |  | Stockholding
 |  | 2899 |  | @ | 1.75 |  |  | 5073.25
 |  | Order Processing: |  |  |  |  |  |  |  | Post Code | Pallets | B | BS | EH | LS | M
 |  | Birmingham |  |  |  |  |  |  |  | B | 1 | 54.4 | 67.71 | 75.49 | 54.4 | 41.07
 | 2013-09-30 00:00:00 | Pick |  | 256 | Cartons |  |  | 76.8 |  |  | 2 | 86.58 | 111.01 | 128.77 | 86.58 | 64.38
 |  | Despatch |  | 9 | Pallets |  |  | 18.9 |  |  | 3 | 111.56 | 146.52 | 163.17 | 111.56 | 79.93
 |  | Delivery of above |  |  |  |  |  | 219.79 |  |  | 4 | 135.42 | 182.05 | 204.25 | 135.42 | 97.68
 | 2013-10-01 00:00:00 | Pick |  | 159 | Cartons |  |  | 47.7 |  |  | 5 | 155.41 | 210.91 | 238.66 | 155.41 | 105.46
 |  | Despatch |  | 5 | Pallets |  |  | 10.5 |  |  | 6 | 176.49 | 233.11 | 266.41 | 176.49 | 119.89
 |  | Delivery of above |  |  |  |  |  | 155.41 |  |  | 7 | 194.26 | 256.42 | 287.5 | 194.26 | 132.09
 | 2013-10-02 00:00:00 | Pick |  | 160 | Cartons |  |  | 48 |  |  | 8 | 208.69 | 275.29 | 319.69 | 208.69 | 133.2
 |  | Despatch |  | 8 | Pallets |  |  | 16.8 |  |  | 9 | 219.79 | 299.71 | 339.68 | 219.79 | 139.86
 |  | Delivery of above |  |  |  |  |  | 208.69 |  |  | 10 | 227.56 | 313.03 | 355.21 | 227.56 | 142.08
 | 2013-10-03 00:00:00 | Pick |  | 109 | Cartons |  |  | 32.7 |  |  | 11 | 227.56 | 313.03 | 355.21 | 227.56 | 142.08
 |  | Despatch |  | 7 | Pallets |  |  | 14.7 |  |  | 12 | 227.56 | 313.03 | 355.21 | 227.56 | 142.08
 |  | Delivery of above |  |  |  |  |  | 194.26 |  |  | 13 | 227.56 | 313.03 | 355.21 | 227.56 | 142.08
 | 2013-10-04 00:00:00 | Pick |  | 0 | Cartons |  |  | 0 |  |  | 14 | 227.56 | 313.03 | 355.21 | 227.56 | 142.08
 |  | Despatch |  | 0 | Pallets |  |  | 0 |  |  | 15 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 |  | Delivery of above |  |  |  |  |  |  |  |  | 16 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 |  |  |  |  |  |  |  | 728.7600000000001 |  |  | 17 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 |  |  |  |  |  |  |  |  |  |  | 18 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 |  | Bristol |  |  |  |  |  |  |  | BS | 19 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 | 2013-09-30 00:00:00 | Pick |  | 110 | Cartons |  |  | 33 |  |  | 20 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 |  | Despatch |  | 4 | Pallets |  |  | 8.4 |  |  | 21 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 |  | Delivery of above |  |  |  |  |  | 182.05 |  |  | 22 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 | 2013-10-01 00:00:00 | Pick |  | 43 | Cartons |  |  | 12.9 |  |  | 23 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 |  | Despatch |  | 2 | Pallets |  |  | 4.2 |  |  | 24 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 |  | Delivery of above |  |  |  |  |  | 111.01 |  |  | 25 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 | 2013-10-02 00:00:00 | Pick |  | 74 | Cartons |  |  | 22.2 |  |  | 26 | 299.43 | 421.25 | 515.74 | 275.52 | 172.5
 |  | Despatch |  | 4 | Pallets |  |  | 8.4
 |  | Delivery of above |  |  |  |  |  | 182.05
 | 2013-10-03 00:00:00 | Pick |  | 24 | Cartons |  |  | 10
 |  | Despatch |  | 3 | Pallets |  |  | 6.300000000000001
 |  | Delivery of above |  |  |  |  |  | 146.52
 | 2013-10-04 00:00:00 | Pick |  |  | Cartons |  |  | 0
 |  | Despatch |  |  | Pallets |  |  | 0
 |  | Delivery of above
 |  |  |  |  |  |  |  | 727.03
 |  | Leeds |  |  |  |  |  |  |  | LS
 | 2013-09-30 00:00:00 | Pick |  | 182 | Cartons |  |  | 54.6
 |  | Despatch |  | 8 | Pallets |  |  | 16.8
 |  | Delivery of above |  |  |  |  |  | 208.69
 | 2013-10-01 00:00:00 | Pick |  | 104 | Cartons |  |  | 31.2
 |  | Despatch |  | 4 | Pallets |  |  | 8.4
 |  | Delivery of above |  |  |  |  |  | 135.42
 | 2013-10-02 00:00:00 | Pick |  | 89 | Cartons |  |  | 26.7
 |  | Despatch |  | 4 | Pallets |  |  | 8.4
 |  | Delivery of above |  |  |  |  |  | 135.42
 | 2013-10-03 00:00:00 | Pick |  | 35 | Cartons |  |  | 10.5
 |  | Despatch |  | 2 | Pallets |  |  | 4.2
 |  | Delivery of above |  |  |  |  |  | 86.58
 | 2013-10-04 00:00:00 | Pick |  |  | Cartons |  |  | 0
 |  | Despatch |  |  | Pallets |  |  | 0
 |  | Delivery of above
 |  |  |  |  |  |  |  | 726.9100000000001
 |  | [NAME] |  |  |  |  |  |  |  | M
 | 2013-09-30 00:00:00 | Pick |  | 491 | Cartons |  |  | 147.3
 |  | Despatch |  | 17 | Pallets |  |  | 35.7
 |  | Delivery of above |  |  |  |  |  | 172.5
 | 2013-10-01 00:00:00 | Pick |  | 143 | Cartons |  |  | 42.9
 |  | Despatch |  | 6 | Pallets |  |  | 12.6
 |  | Delivery of above |  |  |  |  |  | 119.89
 | 2013-10-02 00:00:00 | Pick |  | 147 | Cartons |  |  | 44.1
 |  | Despatch |  | 10 | Pallets |  |  | 21
 |  | Delivery of above |  |  |  |  |  | 142.08
 | 2013-10-03 00:00:00 | Pick |  | 48 | Cartons |  |  | 14.4
 |  | Despatch |  | 4 | Pallets |  |  | 8.4
 |  | Delivery of above |  |  |  |  |  | 97.68
 | 2013-10-04 00:00:00 | Pick |  |  | Cartons |  |  | 0
 |  | Despatch |  |  | Pallets |  |  | 0
 |  | Delivery of above
 |  |  |  |  |  |  |  | 858.55
 |  | D F Wishart
 | 2013-10-04 00:00:00 | Pick |  | 104 | Cartons |  |  | 31.2 |  | EH
 |  | Despatch |  | 5 | Pallets |  |  | 10.5
 |  | Delivery of above |  |  |  |  |  | 238.66
 |  |  |  |  |  |  |  | 280.36
 |  | Edinburgh
 | 2013-10-04 00:00:00 | Pick |  | 30 | Cartons |  |  | 10 |  | EH
 |  | Despatch |  | 2 | Pallets |  |  | 4.2
 |  | Delivery of above |  |  |  |  |  | 128.77
 |  |  |  |  |  |  |  | 142.97
 | Total Charges:
 |  | Goods Receipt |  |  |  |  |  | 107.22
 |  | Storage |  |  |  |  |  | 5073.25
 |  | Order Processing & Delivery |  |  |  | Picking |  | 619.3999999999999
 |  |  |  |  |  | Despatch |  | 199.5
 |  |  |  |  |  | Delivery |  | 2645.68
 |  | [NAME] | 0.102 |  |  |  |  | 269.85936
 |  |  |  |  |  | SubTotal |  | 8914.90936
 |  |  |  |  |  | VAT |  | 1782.981872
 |  |  |  |  |  | Total |  | 10697.891232