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

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