Spreadsheet: 466489d1466207757-look-up-data-from-two-sheets-and-give-a-result-on-a-third-sheet-service-plan-quotes-vs-car-sales
Sheet: Cars Sold

Stock Book Number | Sales Exec Code | Sale Date | Customer Name | Make | Model | Registration | Profit | Reg Date of Car
167380 | 802 | 06/05/16 | Miss E Skiggs | P | 208 Active 1.2 5dr | GU63OYL | 0 | 30/09/2013
167720 | 802 | 11/05/16 | Mrs A Santer | P | 208 Style 1.2 5dr | HY15JWD | 0 | 20/03/2015
167851 | 802 | 13/05/16 | Mr P Parker | P | 308 SW Access 1.6 HDI | EK62WVH | 0 | 08/10/2012
165938 | 802 | 20/05/16 | Mr G Betteridge | P | 3008 Allure 1.6 HDI | AJ62ZCV | 0 | 12/01/2013
163793 | 802 | 31/05/16 | Mr M Deacon | P | xDEMO 5008 Allure 2.0 BHDI | GU65NGE | 0 | 30/11/2015
168114 | 802 | 31/05/16 | Miss [NAME] | P | 207 Envy 1.6 HDI 5dr | LG11WWH | 0 | 12/04/2011
167811 | 803 | 07/05/16 | Mrs J Smith | P | 108 Feline 1.2 5dr | KO15AVT | 0 | 30/06/2015
167422 | 803 | 12/05/16 | Mrs V Matharu | P | 208 Active 1.2 5dr | GU13PYL | 0 | 29/06/2013
166159 | 803 | 14/05/16 | Mrs C Gullard | P | 208 Allure 1.2 5dr | GU63OYJ | 0 | 29/11/2013
167791 | 803 | 19/05/16 | Mr G D Middleton | P | 308 GT Line 1.2 | KJ15CDE | 0 | 28/07/2015
167345 | 803 | 23/05/16 | Mr T Smith | P | 208 Active 1.2 3dr | GU13ZVT | 0 | 10/06/2013
167704 | 803 | 23/05/16 | Mr B Sessions | P | 308 SW Allure 1.2 | KN15PWJ | 0 | [NAME]
166869 | 803 | 31/05/16 | Mrs C Hopkins | P | 208 Access + 1.2 5dr | GX13XSF | 0 | 11/04/2013
166244 | 803 | 31/05/16 | Miss J [NAME] | P | 208 style 1.2 5dr | MM64EXP | 0 | 30/01/2015
168415 | 803 | 31/05/16 | Miss J Pyner | P | 3008 Sport 1.6 Auto | AF11SCV | 0 | 21/03/2011
168618 | 803 | 31/05/16 | Mr S Mewton | P | 108 Allure 1.2 5dr | OU15VTM | 0 | 20/03/2015
166751 | 804 | 06/05/16 | Mr J Langston | P | 107 Active 5dr | GX63FZE | 0 | 28/09/2013
167906 | 804 | 06/05/16 | Mr P Horton | P | 308 Active 1.2 Auto | BG15KVR | 0 | 30/04/2015
165153 | 804 | 06/05/16 | Mr J Cox | P | 308 Allure 1.2 Auto | KW15VAM | 0 | 09/06/2015
168063 | 804 | 06/05/16 | Mr N Redmayne | P | 3008 Allure 1.6 HDI | GU13WWM | 0 | [NAME]
163453 | 804 | 09/05/16 | Mr C Kitchen | P | Partner Prof HDI75 1.6 | GU65YOA | 0 | 30/09/2015
166420 | 804 | 09/05/16 | Mrs C Rix | P | 3008 Allure 1.6 | GV63LKL | 0 | 06/02/2014
166225 | 804 | 13/05/16 | Mrs E Harding | P | 208 Active 1.2 5dr | GU13TTV | 0 | 28/03/2013
167623 | 804 | 13/05/16 | Mrs W Jones | Z | Ford KA 3dr | GU14HUA | 0 | 28/03/2014
168460 | 804 | 16/05/16 | Mr M Peacock | P | 5008 Allure 1.6 HDI Semi-Auto | [NAME] | 0 | 30/04/2014
165811 | 804 | 19/05/16 | Miss [NAME] | P | 3008 Allure 1.6 HDI | [NAME] | 0 | 17/12/2014
164495 | 804 | 21/05/16 | Miss J [NAME] | P | 3008 Active 1.6 HDI | YB15DWA | 0 | 08/06/2015
168111 | 804 | 28/05/16 | Mr L Richardson | P | 308 Active nav 1.6 HDI | GU63RZX | 0 | 27/09/2013
168830 | 804 | 28/05/16 | Mr T Hubble | P | 108 Allure 1.2 5dr | VK15HPC | 0 | 31/03/2015
166813 | 804 | 31/05/16 | Mr J [NAME] | P | 208 GTL 1.2 3dr | LB15LWP | 0 | 21/07/2015
164654 | 805 | 16/05/16 | Mr D Swietlik | P | 2008 Urban Cross 1.2 | GX65KYG | 0 | 30/09/2015
166710 | 805 | 20/05/16 | Mrs J Swietlik | P | 2008 Allure 1.2 | YO15NKT | 0 | 31/07/2015
168538 | 805 | 23/05/16 | Mrs A [NAME] | P | 208 Allure 1.6 5dr Auto | GX13OAV | 0 | 24/05/2013
168947 | 805 | 27/05/16 | Mrs S Hall | P | 5008 Allure 2.0 HDI Auto | KS15FSJ | 0 | 29/04/2015
167990 | 806 | 05/05/16 | Mr K Gander | P | 3008 Allure 2.0 HDI Auto | KW15UZN | 0 | 09/06/2015
167386 | 806 | 12/05/16 | [NAME] | P | 108 Allure 1.2 5dr | GX15XXH | 0 | 13/03/2015
167507 | 806 | 12/05/16 | Mr J Martin | P | 108 Active 1.0 5dr 2tr | KN15POU | 0 | 27/03/2015
166526 | 806 | 25/05/16 | Mrs P Dorey | P | 108 Active 1.0 5dr | SM64WTE | 0 | 31/01/2015
166473 | 806 | 25/05/16 | Mrs I Barden | P | 107 Allure 5dr | GF12RVX | 0 | [NAME]
167823 | 806 | 25/05/16 | Mr M Stansmore | P | 308 Active 1.6 HDI | YG15VVU | 0 | 27/03/2015
168668 | 806 | 26/05/16 | Mr P Wickson | P | 208 Allure 1.6 3dr Auto | LD13HXK | 0 | 09/05/2013
168398 | 807 | 20/05/16 | Mrs C Sopp | P | 207 CC 1.6 | AD59EUY | 0 | 29/01/2010
168155 | 807 | 24/05/16 | [NAME] | P | RCZ 1.6 GT 200 | GU14RUY | 0 | 18/03/2014
168583 | 807 | 27/05/16 | Mr P Moore | P | 308 Allure 1.6 BHDI | GU15JZC | 0 | 09/03/2015