Spreadsheet: 83540d1283507735-vlookup-spend-figures-test
Sheet: Reporting

 |  | CUSTOMER | Ashby | Cardiff | Dundee | [NAME] | Luton | Middlesborough | Sheffield | West Brom/ Birmingham | Wolverhampton/ Walsall
 | 8 | AUGUST | 150000 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 150044
8 |  | AUGUST EXCLUDED | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 135
 | 9 | SEPTEMBER |  |  |  |  |  |  |  |  |  | 0
9 |  | SEPTEMBER EXCLUDED |  |  |  |  |  |  |  |  |  | 0
 | 10 | OCTOBER |  |  |  |  |  |  |  |  |  | 0
10 |  | OCTOBER EXCLUDED |  |  |  |  |  |  |  |  |  | 0
 | 11 | NOVEMBER |  |  |  |  |  |  |  |  |  | 0
11 |  | NOVEMBER EXCLUDED |  |  |  |  |  |  |  |  |  | 0
 | 12 | DECEMBER |  |  |  |  |  |  |  |  |  | 0
12 |  | DECEMBER EXCLUDED |  |  |  |  |  |  |  |  |  | 0
 | 1 | JANUARY | 1000 |  |  |  |  |  |  |  |  | 1000
1 |  | [NAME] | 100 |  |  |  |  |  |  |  |  | 100
 | 2 | FEBRUARY |  |  |  |  |  |  |  |  |  | 0
2 |  | FEBRUARY EXCLUDED |  |  |  |  |  |  |  |  |  | 0
 | 3 | [NAME] |  |  |  |  |  |  |  |  |  | 0
3 |  | [NAME] |  |  |  |  |  |  |  |  |  | 0
 | 4 | APRIL |  |  |  |  |  |  |  |  |  | 0
4 |  | APRIL EXCLUDED |  |  |  |  |  |  |  |  |  | 0
 | 5 | MAY |  |  |  |  |  |  |  |  |  | 0
5 |  | MAY EXCLUDED |  |  |  |  |  |  |  |  |  | 0
 | 6 | [NAME] |  |  |  |  |  |  |  |  |  | 0
6 |  | [NAME] |  |  |  |  |  |  |  |  |  | 0
 | 7 | JULY |  |  |  |  |  |  |  |  |  | 0
7 |  | JULY EXCLUDED |  |  |  |  |  |  |  |  |  | 0
 |  | SALES TOTAL | 151000 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 151044
 |  | EXCLUDED SALES | 111 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 235
 |  |  | A | B | C | D | E | F | G | H | I
 |  | Working Cumulative Totals
 |  |  | LEICESTER | BEARING TRADERS | CITY BRGS. & TRAN. | BRT | PREMIER BRG | STOCKTON | CITY [NAME] | GOLDLINE | SWAN
 |  | Jan | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Feb | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Mar | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Apr | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | May | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Jun | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Jul | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Aug | 151000 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | Sep | 151000 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | Oct | 151000 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | Nov | 151000 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | Dec | 151000 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  | 9 | 1 | 3 | 2 |  |  | 4 | 5 | 6
 |  | ABA | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A
 |  | EIS | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A
 |  | ABCO | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A
 |  | BEARING TRADERS | 2 | 0 | 0 | 0 |  |  | 0 | 0 | 0
 |  | BRT | 4 | 0 | 0 | 0 |  |  | 0 | 0 | 0
 |  | CITY BRGS. & TRAN. | 3 | 0 | 0 | 0 |  |  | 0 | 0 | 0
 |  | CITY [NAME] | 7 | 0 | 0 | 0 |  |  | 0 | 0 | 0
 |  | GOLDLINE | 8 | 0 | 0 | 0 |  |  | 0 | 0 | 0
 |  | SWAN | 9 | 0 | 0 | 0 |  |  | 0 | 0 | 0
 |  | ITEC PWR. SRV. | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A
 |  | J & M BELTS | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A
 |  | LEICESTER | 151000 | 1000 | 1000 | 1000 |  |  | 1000 | 1000 | 1000
 |  | LONDON | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A
 |  | MOTION INDUSTRIES | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A
 |  | ORBIC | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A
 |  | PREMIER BRG | 5 | 0 | 0 | 0 |  |  | 0 | 0 | 0
 |  | PREMIER POWER | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A
 |  | SPEN | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A
 |  | STOCKTON | 6 | 0 | 0 | 0 |  |  | 0 | 0 | 0