Spreadsheet: 221735d1363650879-trying-to-retrieve-information-from-worksheet-to-a-form-workbook3-jacc
Sheet: Drop Down List

Sl # |  | Publisher |  | Customer Division |  | Sub-Division |  | Job Code |  | ISBN | Customer Contact | Author | Title | Date of Receipt | Country | Currency | Project Manager |  | In-house / Freelance |  | [NAME] |  | Date of Outsourcing | Estimated Completion | Estimated Value | Estimated Value | Outsourcing Contract Value | Outsourcing Cost % | % of Work Completion | Type of Design Service | Lookup value | Partial Billing | Date | Partial Billing | Date | [NAME] | Date
 |  | Pearson |  | India |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Freelance |  | N/A |  |  |  |  |  |  |  |  | 1. IDM Adaptation, Simple - Core book | 325
 |  | CUP |  | BC |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In-house |  | [NAME] |  |  |  |  |  |  |  |  | 2. IDM Adaptation, Moderate - Core Book | 750
 |  | BSM |  | PHNJ |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Freelance + In-house |  | Rae Grant |  |  |  |  |  |  |  |  | 3. IDM Adaptation,AISE/ISE or Ancillary | 150
 |  | Cengage |  | AW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 4. IDM Adaptation, PAL | 300
 |  |  |  | CENNY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 5. IDM Adaptation, Series | 500
 |  |  |  | CENBEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 6. IDM New Simple - Core Book | 750
 |  |  |  | CENMAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 7. IDM New Moderate - Core Book | 850
 |  |  |  | Bedford St. Martin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 8. IDM New Complex - Core Book | 950
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TBD |  |  |  |  |  |  |  |  | 9. IDM New Series | 1500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10. CM Templated Series Pickup and Modify | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11. CM Adaptation, Simple - Core Book | 225
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12. CM Adaptation, Moderate - Core Book | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13. CM New. Core Book | 525
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14. CM New, Series Design | 750
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15. CD Simple - Core Book | 1250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16. CD Moderate - Core Book | 1500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17. CD AISE/ISE or non-templated Ancillary | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18. CD Complex, Core Book | 2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19. CD Series Design | 2250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20. Mechanical - Core Book | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21. Mechanical (IE, ISE, AISE, ADV, Splits) | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22. [NAME] | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23. ID Adaptation, Simple Core Book | 1500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24. ID Adaptation, Moderate - core Book | 2500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25. ID Adaptation, PAL Stylesheet | 1500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26. ID New, Simple - Core Book | 2500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27. ID New, Moderate - Core Book | 3500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28. ID New, Complex - Core Book | 6000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29. ID Series Design | 6500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cover
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Interior1 | 1200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Interior2 | 800