Spreadsheet: 105646d1302947535-vlookup-perhaps-example
Sheet: Sheet1

CUSTOMER NUMBER | SITE # | ISALES # | CHANGE REQUEST | CUSTOMER NAME | ADDRESS DETAILS 1 | SUBURB | STATE | POSTCODE | CONTACT NAME | PHONE | ABN # | PO # | SITE ADDRESS | ADDRESS DETAILS | SUBURB | STATE | POSTCODE | CONTACT NAME | PHONE NUMBER | NEW / RESIGN | WEEKLY $ | CONTRACT TERM | LINE TYPE | LINE NUMBER | BILLED | NEW / RESIGN | WEEKLY $ | CONTRACT TERM | MAINT TYPE | MAINT VISITS | BILLED | NOTES 1 | NOTES 2 | NOTES 3 | NOTES 4 | NOTES 5 | DATE ENTERED | TIME ENTERED | NAC TIMEFRAME | NOW TIME | TIME WHEN VIOLATION OCCURS | VIOLATION | STATUS | DATE TIME APPROVED | SLA VIOLATION | SW NUMBER | COMMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | OPEN
5041489 | NEW | 41547 | I-SALES 2 - EXISTING CUSTOMER, NEW SYSTEM OR SERVICE TYPE, NEW SITE | CAPUCHIN | GPO BOX 2163 | ADELAIDE | SA | 5001 | [NAME] | [PHONE] | 34700839339 | N/A | CAPUCHIN | 4 ANGUS STREET | KENT TOWN | SA | 5067 | [NAME] | [PHONE] | NEW | 15 | 60 MONTHS | TELSTRA SECURE | NEW | QUARTERLY | . | . | . | . | . | . | EXISTING CUSTOMER NEW SITE | INSTALL WORKS |  | . | . |  |  |  |  |  |  | OPEN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | URGENT |  |  |  | I-SALES 1 - NEW CUSTOMER, NEW SYSTEM/SERVICE TYPE, NEW SITE
5051427 | NEW | 42447 | I-SALES 2 - EXISTING CUSTOMER, NEW SYSTEM OR SERVICE TYPE, NEW SITE | NINE WEST | COMO OFFICE TOWERS 644 CHAPEL STREET | SOUTH YARRA | VIC | 3141 | WILLIS | [PHONE] |  | 01402 | [NAME] | 237 RUNDLE STREET | ADELAIDE | SA | 5000 | LAURA RICHARDSON | [PHONE] | NEW | 5 | 60 MONTHS | DIALLER | QHH-394 | QUARTERLY |  |  |  |  |  |  | EXISTING CUSTOMER NEW SITE | LINE HAS ALREADY BEEN SET UP NEED TO ADD CONTACTS/COST ETC. | SERVICE WORKS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HIGH |  |  |  | I-SALES 2 - EXISTING CUSTOMER, NEW SYSTEM OR SERVICE TYPE, NEW SITE
5034765 | 276933-003 | 42245 | I-SALES 4 - EXISTING CUSTOMER, EXTRA WORK ON AN EXISTING CHUBB INSTALL JOB - PROJECT VARIATION | ROMALDI CONSTRUCTIONS PTY LTD | 125 PORT ROAD | HINDMARSH | SA | 5007 | BARBARA |  | 50059740368 | N/A | SOUTHERN INTERMEDIATE CARE | LOT 97 JACKSON PLACE | NOARLUNGA | SA | 5168 | [NAME] | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | NEGATIVE VARIATION ONLY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MEDIUM |  |  |  | I-SALES 3 - EXISTING CUSTOMER, NEW SYSTEM OR SERVICE TYPE, EXISTING SITE
5034765 | 276933-003 | 42237 | I-SALES 4 - EXISTING CUSTOMER, EXTRA WORK ON AN EXISTING CHUBB INSTALL JOB - PROJECT VARIATION | ROMALDI CONSTRUCTIONS PTY LTD | 125 PORT ROAD | HINDMARSH | SA | 5007 | BARBARA |  | 50059740368 | N/A | SOUTHERN INTERMEDIATE CARE | LOT 97 JACKSON PLACE | NOARLUNGA | SA | 5168 | [NAME] | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | VARIATION ONLY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOW |  |  |  | I-SALES 4 - EXISTING CUSTOMER, EXTRA WORK ON AN EXISTING CHUBB INSTALL JOB - PROJECT VARIATION
5030174 | 61906-002 | 42625 | I-SALES 7 - EXISTING CUSTOMER, UPGRADE OR EXTENSION TO AN EXISTING SYSTEM | CONSTELLATION WINE TINTARAWINER | 37-53 REYNELL ROAD | OLD REYNELLA | SA | 5161 | CATHY VENNING |  | 26008273907 | 841871 | CONSTELLATION WINE AUSTRALIA | 202 MAIN ROAD | [NAME] | SA | 5171 | GRAHAM DEERING | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | SENT TO BACK END 11/11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROJECTS |  |  |  | I-SALES 5 - NEW CUSTOMER, TAKE OVER OF EXISTING SYSTEM INSTALLED BY A COMPETITOR
5033078 | 1176-001 | 42664 | I-SALES 7 - EXISTING CUSTOMER, UPGRADE OR EXTENSION TO AN EXISTING SYSTEM | BAE SYSTEM AUSTRALIA | PO BOX 1068 | SALISBURY | SA | 5108 | JANE PASCOE |  | 50062283309 | N/A | BAE SYSTEMS AUST VARIOUS | TARANAKI ROAD | EDINBURGH PARKS | SA | 5111 | [NAME] | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | SENT TO BACK END 11/11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER |  |  |  | I-SALES 4 - EXISTING CUSTOMER, EXTRA WORK ON AN EXISTING CHUBB INSTALL JOB - PROJECT VARIATION
5039092 | 77243-008 | 42598 | I-SALES 7 - EXISTING CUSTOMER, UPGRADE OR EXTENSION TO AN EXISTING SYSTEM | GLENSIDE CAMPUS | PO BOX 17 | FULLARTON | SA | 5063 | WAYNE ASTON | [PHONE] |  |  | GLENSIDE CAMPUS PRECINCT 1 | 226 FULLARTON ROAD | EASTWOOD | SA | 5063 | WAYNE ASTON | [PHONE] | NEW | 12.5 | 12 MONTHS | TELSTRA SECURE | UTS-1697 | QUARTERLY |  |  |  |  |  |  | PLEASE REMOVE ALL REFERENCE TO DEADSHORT ELECTRICAL FROM PRONTO | USE LINE NUMBER UTS-1697 | SERVICE WORKS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I-SALES 5 - NEW CUSTOMER, TAKE OVER OF EXISTING SYSTEM INSTALLED BY A COMPETITOR
5057239 | 71075-001 | 29913 | I-SALES 7 - EXISTING CUSTOMER, UPGRADE OR EXTENSION TO AN EXISTING SYSTEM | OLYMPIC JEWELLERS | 3-5 RUNDLE MALL | ADELAIDE | SA | 5000 | NICK |  | 35007955375 |  | OLYMPIC JEWELLERS | 3-5 RUNDLE MALL | ADELAIDE | SA | 5000 | CON ARSENIKAKIS | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | SENT TO BACK END 12/11 | SERVICE WORKS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I-SALES 6 - NEW CUSTOMER, TAKE OVER OF AN EXISTING SYSTEM INSTALLED BY CHUBB (NEW OWNER)
 |  |  | if customer number is entered in A and it is already listed I want E,F,GH,I,J,K & L to fill the same details