Spreadsheet: 59704d1260284537-extract-lookup-from-another-worksheet-prospect-form
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | LOGO HERE
 | FORM INCOMPLETE - DO NOT SUBMIT
 |  | SECTION ONE |  | *TO BE COMPLETED IN FULL BY ORIGINATOR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contact Menu
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Originator |  |  |  |  |  |  |  |  |  | Sales office |  |  |  |  |  |  |  |  |  | Sales Office - Cold Call | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prospect called in
 |  | Date |  |  |  |  |  |  |  |  | How was contact made? |  |  |  |  |  |  |  | * |  |  | Emailed in from Website | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *SELECT FROM LIST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | PROSPECT DETAILS
 |  | Contact Name |  |  |  |  |  |  |  |  |  | Position |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Full Trading Name of Business |  |  |  |  | ABS tyres |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | Please check >> |  |  |  |  | ABS Tyres
 |  | Nature of business |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Why is account required? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Date business established |  |  |  |  |  |  |  |  |  | Type of business |  |  |  |  |  |  | * |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *SELECT FROM LIST
 |  |  |  | *SELECT FROM LIST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Car dealership? |  |  |  |  | * | If YES, vehicle manufacturer |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Number of tyres sold per month |  |  |  |  |  |  |  |  | New |  |  |  |  |  | Part worn |  |  |  |  |  | 0
 |  | Total monthly spend on tyres |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Business Menu
 |  | Principal tyre suppliers |  |  |  |  | WHOLESALERS |  |  |  |  |  | MANUFACTURERS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Limited
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Partnership
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | dealership menu
 |  | Address in full |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Post code |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Telephone |  |  |  |  |  |  |  | Fax number |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Additional Comments
 |  | SECTION TWO |  | *TO BE COMPLETED IN FULL BY B.D.M
 |  | Visited by |  |  |  |  |  |  |  |  |  | Date
 |  | Key Contact 1 |  |  |  |  |  |  |  | Key contact 2
 |  | Number of Staff |  |  |  |  |  |  |  | Average stock levels
 |  | Current brands |  |  |  |  |  |  |  | Current suppliers
 |  | Stocked
 |  | Services offered - please delete as appropriate*
 |  | Mechanical Repairs |  |  | YES |  |  | NO |  | *       Commercial |  |  | YES | NO |  | *
 |  | Exhausts |  |  | YES |  |  | NO |  | *       Motorcycle |  |  | YES | NO |  | *
 |  | MOTS |  |  | YES |  |  | NO |  | *       Agricultural |  |  | YES | NO |  | *
 |  | Batteries |  |  | YES |  |  | NO |  | *
 |  | Sales forecast
 |  | Units month 1 |  |  |  |  |  |  |  | Units month 3
 |  | Units month 2 |  |  |  |  |  |  |  | Units month 4
 |  | SECTION 3 |  | *TO BE COMPLETED IN FULL BY B.D.M
 |  | Account form complete |  |  | YES |  | NO |  | * | Direct Debit form completed |  |  |  |  | YES |  | NO |  | *
 |  | If NO Direct Debit, give reason
 |  | Centerally billed |  |  | YES |  | NO |  | * | House brand |  |  | YES | NO |  | *
 |  | Territory |  |  |  |  |  |  |  | Which brand
 |  | List price |  |  |  |  |  |  |  |  | ESP |  | YES | NO |  | *
 |  | Delivery depot |  |  |  |  |  |  |  |  |  |  | please delete as appropriate*