Spreadsheet: 59343d1259841932-vlookup-within-vlookups-new-copy
Sheet: Sheet1

Job File |  |  |  |  |  |  |  |  | Date |  |  |  |  |  |  |  |  |  |  |  | 2009-11-30 00:00:00
 |  |  |  |  |  |  |  |  | Quote |  |  |  |  |  |  |  |  |  |  |  | 81105
AWB |  |  |  |  |  |  |  |  | AGL ref |  |  |  |  |  |  |  |  |  |  |  | 10/1105/09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  | Shipper ref |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
Certified AWB |  |  |  |  |  |  |  |  | Shipper short code |  |  |  |  |  |  |  |  |  |  |  | TEST12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  | Shipper |  |  |  |  |  |  |  |  |  |  |  | TEST12
Certificate of Origin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST12
Commercial Invoice |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST12
Confirmation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST12
 |  |  |  |  |  |  |  |  | Contact |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is where you choose the consignee
Collection / Delivery Note |  |  |  |  |  |  |  |  | Consignee |  |  |  |  |  |  |  |  |  |  |  | consignee K12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | associated with the shipper
Certificate of Shipment
Invoice
2nd Invoice |  |  |  |  |  |  |  |  | Notify
3rd Invoice
Import Duty Invoice
Credit Note |  |  |  |  |  |  |  |  | Loading cargo at
2nd Credit Note
House B/L Front Original
House B/L Front Copy |  |  |  |  |  |  |  |  | Collection date |  |  |  |  |  |  |  |  |  |  |  | 2009-11-30 00:00:00
 |  |  |  |  |  |  |  |  | Collection time |  |  |  |  |  |  |  |  |  |  |  | 18:45:00 |  |  |  |  |  |  |  |  |  |  |  |  | hrs
House B/L Back |  |  |  |  |  |  |  |  | Haulage by
 |  |  |  |  |  |  |  |  | Shipping line
Shipment Advice |  |  |  |  |  |  |  |  | Departure airport
 |  |  |  |  |  |  |  |  | [NAME] airport
 |  |  |  |  |  |  |  |  | Final destination
 |  |  |  |  |  |  |  |  | Flight number
 |  |  |  |  |  |  |  |  | ETS
 |  |  |  |  |  |  |  |  | Connecting airport
 |  |  |  |  |  |  |  |  | ETS
 |  |  |  |  |  |  |  |  | ETA
 |  |  |  |  |  |  |  |  | Time |  |  |  |  |  |  |  |  |  |  |  | 18:45:00 |  |  |  |  |  |  |  |  |  |  |  |  | hrs
 |  |  |  |  |  |  |  |  | Freight charges payable
 |  |  |  |  |  |  |  |  | Other charges payable
 |  |  |  |  |  |  |  |  | Declared value of goods
 |  |  |  |  |  |  |  |  | Amount of insurance
 |  |  |  |  |  |  |  |  | Shipping marks &/or case numbers
 |  |  |  |  |  |  |  |  | Number and kind of packages
 |  |  |  |  |  |  |  |  | Dimensions |  |  |  |  |  |  |  |  |  |  |  |  | @ |  |  |  | x |  |  |  | x |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ |  |  |  | x |  |  |  | x |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ |  |  |  | x |  |  |  | x |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ |  |  |  | x |  |  |  | x |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ |  |  |  | x |  |  |  | x |  |  |  | cms
 |  |  |  |  |  |  |  |  | Total number of items
 |  |  |  |  |  |  |  |  | Gross weight |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | kgs
 |  |  |  |  |  |  |  |  | Chargeable weight |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | kgs
 |  |  |  |  |  |  |  |  | Cube |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m³
 |  |  |  |  |  |  |  |  | Booking ref
 |  |  |  |  |  |  |  |  | MAWB no
 |  |  |  |  |  |  |  |  | Booking confirmation date
 |  |  |  |  |  |  |  |  | Invoice date