Spreadsheet: 466537d1466261110-look-up-data-from-two-sheets-and-give-a-result-on-a-third-sheet-service-plan-quotes-vs-car-sales-ndm
Sheet: Service Plans

Group1 | Group2 | Textbox16 | IsUsedCarQuote2 | DeptQuoteTotal | IsNewCarSale2 | IsUsedCarSale2 | DeptSaleTotal | Textbox23 | Group3 | IsNewCarQuote | IsUsedCarQuote | QuoteTotal | IsNewCarSale | IsUsedCarSale | SaleTotal | Textbox120 | Sold | Reference | Surname | DDDescrip | RegistrationNumber | QuoteDate | SaleDate | IsNewCarQuote1 | IsUsedCarQuote1 | Textbox140 | IsNewCarSale1 | IsUsedCarSale1 | Textbox143 | Textbox144
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 6 | 6 | 0 | 0 | 0 | 0 | Not Sold | FPGDT |  | Low Deposit | GU63OYL | 2016-05-06 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 6 | 6 | 0 | 0 | 0 | 0 | Not Sold | FR4RB |  | Low Deposit | HY15JWD | 2016-05-11 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 6 | 6 | 0 | 0 | 0 | 0 | Not Sold | FR59B |  | Low Deposit | GY16GWC | 2016-05-11 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 6 | 6 | 0 | 0 | 0 | 0 | Not Sold | FRG1B |  | Low Deposit | EK62WVH | 2016-05-13 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 6 | 6 | 0 | 0 | 0 | 0 | Not Sold | FRZZL |  | Fixed payments | GU65NGE | 2016-05-17 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 6 | 6 | 0 | 0 | 0 | 0 | Not Sold | FTG00 |  | Low Deposit | AJ62ZCV | 2016-05-20 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 7 | 7 | 0 | 3 | 3 | 0.43 | Not Sold | FRHRV | [NAME] | Fixed payments | GU13TTV | 2016-05-13 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 7 | 7 | 0 | 3 | 3 | 0.43 | Not Sold | FTV8M | [NAME] | Fixed payments | [NAME] | 2016-05-24 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 7 | 7 | 0 | 3 | 3 | 0.43 | Not Sold | FVFB8 | Richardson | Pay in full today | GU63RZX | 2016-05-28 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 7 | 7 | 0 | 3 | 3 | 0.43 | Not Sold | FVP0C | [NAME] | Fixed payments | GY16JXS | 2016-05-31 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 7 | 7 | 0 | 3 | 3 | 0.43 | Sold by: [NAME] | FRH42 | Jones | Fixed payments | GU14HUA | 2016-05-13 00:00:00 | 2016-05-13 00:00:00 | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 7 | 7 | 0 | 3 | 3 | 0.43 | Sold by: [NAME] | FTJD6 | [NAME] | Fixed payments | YB15DWA | 2016-05-21 00:00:00 | 2016-05-21 00:00:00 | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 0 | 7 | 7 | 0 | 3 | 3 | 0.43 | Sold by: [NAME] | FV4JR | Hubble | Low Deposit | VK15HPC | 2016-05-26 00:00:00 | 2016-05-26 00:00:00 | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | [NAME] |  | Fixed payments | GY16EAA | 2016-05-06 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | FPFPK |  | Fixed payments | GU14GWA | 2016-05-06 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | FPPLG |  | Fixed payments | GY16CPU | 2016-05-09 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | FPR2D |  | Fixed payments | GU16ZPC | 2016-05-09 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | FPRBL |  | Fixed payments | GV16THK | 2016-05-09 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | FR37G |  | Fixed payments | YX13LGL | 2016-05-11 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | FR41T |  | Fixed payments | GY13CDZ | 2016-05-11 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | FRDW4 |  | Fixed payments | GU63OYJ | 2016-05-13 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | FT4N0 |  | Fixed payments | KJ15CDE | 2016-05-18 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | FT51L |  | Fixed payments | KN15PWJ | 2016-05-18 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | [NAME] |  | Fixed payments | GU13ZVT | 2016-05-18 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | FV8WK |  | Fixed payments | AF11SCV | 2016-05-27 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Not Sold | FV8Z5 |  | Fixed payments | MM64EXP | 2016-05-27 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Sold by: [NAME] | FR75K | Matharu | Fixed payments | GU13PYL | 2016-05-12 00:00:00 | 2016-05-12 00:00:00 | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 5 | 10 | 15 | 1 | 1 | 2 | 0.13 | Sold by: [NAME] | FR9JC | [NAME] | Fixed payments | GY16WWH | 2016-05-12 00:00:00 | 2016-05-12 00:00:00 | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 3 | 6 | 9 | 2 | 1 | 3 | 0.33 | Not Sold | FPCB8 |  | Fixed payments | KW15UZN | 2016-05-05 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 3 | 6 | 9 | 2 | 1 | 3 | 0.33 | Not Sold | FPDC9 |  | Fixed payments |  | 2016-05-05 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 3 | 6 | 9 | 2 | 1 | 3 | 0.33 | Not Sold | FPR9R |  | Fixed payments | GX16MXP | 2016-05-09 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 3 | 6 | 9 | 2 | 1 | 3 | 0.33 | Not Sold | FRCL9 |  | Fixed payments | GX15XXH | 2016-05-12 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 3 | 6 | 9 | 2 | 1 | 3 | 0.33 | Not Sold | FRR0Y |  | Fixed payments | GF12RVX | 2016-05-16 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 3 | 6 | 9 | 2 | 1 | 3 | 0.33 | Not Sold | FV4PN |  | Fixed payments | LD13HXK | 2016-05-26 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 3 | 6 | 9 | 2 | 1 | 3 | 0.33 | Sold by: [NAME] | FR58X | Bloomfield | Fixed payments | GY16WWG | 2016-05-11 00:00:00 | 2016-05-12 00:00:00 | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 3 | 6 | 9 | 2 | 1 | 3 | 0.33 | Sold by: [NAME] | FPXP8 | [NAME] | Fixed payments | BC02CFC | 2016-05-10 00:00:00 | 2016-05-11 00:00:00 | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Sales | 8 | 29 | 37 | 3 | 5 | 8 | 0.22 | [NAME] | 3 | 6 | 9 | 2 | 1 | 3 | 0.33 | Sold by: [NAME] | FV8M7 | [NAME] | Fixed payments | SM64WTE | 2016-05-27 00:00:00 | 2016-05-27 00:00:00 | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | April Poston | 0 | 7 | 7 | 0 | 2 | 2 | 0.29 | Not Sold | FRK03 | Hills | Fixed payments | GU14EWD | 2016-05-14 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | April Poston | 0 | 7 | 7 | 0 | 2 | 2 | 0.29 | Not Sold | FRG89 | Silver | Low Deposit | A4GPS | 2016-05-13 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | April Poston | 0 | 7 | 7 | 0 | 2 | 2 | 0.29 | Not Sold | [NAME] |  | Fixed payments | YE14HSZ | 2016-05-23 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | April Poston | 0 | 7 | 7 | 0 | 2 | 2 | 0.29 | Not Sold | FVFG5 | [NAME] | Low Deposit | LR13FJD | 2016-05-28 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | April Poston | 0 | 7 | 7 | 0 | 2 | 2 | 0.29 | Not Sold | FTLK9 | [NAME] | Low Deposit | GV12UAK | 2016-05-23 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | April Poston | 0 | 7 | 7 | 0 | 2 | 2 | 0.29 | Sold by: [NAME] | FP0J8 | Bonser | Fixed payments | R20BDB | 2016-05-03 00:00:00 | 2016-05-04 00:00:00 | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | April Poston | 0 | 7 | 7 | 0 | 2 | 2 | 0.29 | Sold by: [NAME] | FTPVW | [NAME] | Low Deposit | YE14HSZ | 2016-05-23 00:00:00 | 2016-05-23 00:00:00 | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 0 | 1 | 1 | 0 | 0 | 0 | 0 | Not Sold | FTTBJ | Hine | Fixed payments | GV13GXY | 2016-05-24 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FP1HX | [NAME] | Low Deposit | GX13OAV | 2016-05-03 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FPBDN | Madden | Low Deposit | GY13UHX | 2016-05-05 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FP49G | Deacon | Low Deposit | DS11OSN | 2016-05-04 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FPHW8 | Lodge | Low Deposit | YA13XBC | 2016-05-06 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FR17W | Mills | Low Deposit | GY10XAC | 2016-05-11 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FRWYB |  | Fixed payments | GY61WDC | 2016-05-17 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | [NAME] |  | Fixed payments | EK58ZKA | 2016-05-24 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FRRXF | [NAME] | Low Deposit | GY13WMJ | 2016-05-16 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FRTKT | [NAME] | Low Deposit | MV10SXD | 2016-05-16 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FRWYT | Chinnick | Low Deposit | GY61WDC | 2016-05-17 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FRXWY | [NAME] | Low Deposit | HK08UVM | 2016-05-17 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FTM1B | Jones | Low Deposit | GY10PZE | 2016-05-23 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FTT03 | Bulpitt | Low Deposit | GV10FVB | 2016-05-24 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FV50Y | Hewlitt | Low Deposit | B11CCH | 2016-05-26 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Not Sold | FVP7B | Hester | Low Deposit | WK12URE | 2016-05-31 00:00:00 |  | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Sold by: [NAME] | FRY0X | Waldie | Low Deposit | DL11VMD | 2016-05-17 00:00:00 | 2016-05-17 00:00:00 | 9 | 53 | 62 | 3 | 9 | 12 | 0.19
Site 008 | Service | 1 | 24 | 25 | 0 | 4 | 4 | 0.16 | [NAME] | 1 | 16 | 17 | 0 | 2 | 2 | 0.12 | Sold by: [NAME] | FV2GM | [NAME] | Low Deposit | GU12JYW | 2016-05-25 00:00:00 | 2016-05-25 00:00:00 | 9 | 53 | 62 | 3 | 9 | 12 | 0.19