Spreadsheet: 148584d1333473824-need-vlookup-to-track-if-i-have-multiple-entries-for-the-same-site-number-customerfile
Sheet: Sheet1

Actual Circuit Order Issue Date | CRDD | [NAME] | eBonding Tracking Number | Project/ Sales Order Number | Circuit USO | PORT USO | PVC USO | Local Business Name (Site Type) | Alternate location name (Customer Station Name) | Address | Floor | Suite | City | State | Zip | [NAME] (Primary) | Store NPA/NXX | Local Contact (Store Manager) | LCON phone (Store Mgr. Cell) | LCON e-mail ID | MPLS port type | Port speed | Current connection LEC ID | Notes for the Access installer | VPN Name | CIR of PVC | CoS profile | PER IP address | CER IP address | Subnet mask | Routing protocol | Autonomous System Number (ASN) | ASN Override? | Restrictive Routing? | Multicast enabled? | LEC Name | New AT&T Circuit ID | New LEC Circuit ID | DMARC Information | Scheduled FOC Date - Receipt of Firm Order Confirmation Date | Actual FOC  Date - Access Delivery date Recieved | Scheduled EAD Date - Estimted Access Delivery | Actual EAD Date - Access Delivered | Scheduled CTA Date - Target Circuit End to End Testing | Actual [NAME] to End Testing complete | Scheduled Due Date - Circuit Order Completion | Actual Due Date - Circuit Order Complete | Scheduled Due Date - Port Order | Actual Due Date - Completed Port Order | PVC DD Scheduled - Connection to the network | PVC DD Completed - Connection to the network | Notes on Circuit Issues | Reason for [NAME] (ATT/LEC/Cust) | Router [NAME] Issue Date | Router [NAME] | Site  Router Reqrement (NR/WIC) | Router/ WIC Delivered | Vendor Site Survey Scheduled | Vendor Site Survey Compl Date | Exceptions/ Issues | Site Survey Cost (Provided by Sears - Larry) | Vendor IW/dmarc Ext Scheduled | Vendor IW/dmarc Ext Compl Date | Contractor Notification to extend circuit- sent date | Circuit Extension-Scheduled Date Issued(Due 48 Hours after notificatn) | Circuit Extension- Actual Completion Date (7- 10 days after [NAME]) | Circuit Extension Estimated Cost or N/A  (From Site Survey) | Circuit Extension Actual Cost (From Sears) | Pre-Cert Request Date | Pre-Cert Compl | Port Activatn Request Date | Port Activtnt Complete | Vendor/ LCON Scheduled Y/N | Planned T&TU Date | Sched T&TU Date | Actual T&TU Date | Notes on T&TU Fallouts | Reason for FallOut (AT&T/ Cust)
2012-03-21 00:00:00 | 2012-05-07 00:00:00 | 1008A |  | VS12060499 |  | 3441-0475 | 3441-BDZJ | Sears (Full Line) Store | 1008 | 2650 E OLYMPIC BL | 1 | Comp | LOS ANGELES | CA | 90023 | [PHONE] | 323-981 | Ops Mgr | [PHONE] | [EMAIL] | PPP | 5Meg 5000 Full T45 with Total Service | 13/HCGS/669096//PT | Del. to store (not mall) demarc by existing LEC circuit #13/HCGS/669096//PT | [NAME] | 5M | 0.25,0.3,0.05,0.15,0.4,0.1 | 10.221.0.25 | 10.221.0.26 | 255.255.255.252 | [NAME] | 64701 | No | No | Yes | ATT-W | DNEC615585   ATI |  |  | 2012-03-28 00:00:00 |  | 2012-04-05 00:00:00 |  | 2012-05-03 00:00:00 |  | 2012-05-07 00:00:00 |  |  |  | 2012-05-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-17 00:00:00
2012-03-21 00:00:00 | 2012-05-07 00:00:00 | 1008B |  | VS12060532 |  | 3441-0491 | 3441-BDZN | Sears (Full Line) Store | 1008 | 2650 E OLYMPIC BL | 1 | Comp | LOS ANGELES | CA | 90023 | [PHONE] | 323-981 | Ops Mgr | [PHONE] | [EMAIL] | PPP | 5Meg 5000 Full T45 with Total Service | 13/HCGS/669096//PT | Del. to store (not mall) demarc by existing LEC circuit #13/HCGS/669096//PT | [NAME] | 5M | 0.25,0.3,0.05,0.15,0.4,0.1 | 10.221.0.29 | 10.221.0.30 | 255.255.255.252 | [NAME] | 64701 | No | No | Yes | ATT-W | DNEC628406   ATI | 13HFGS586493PT |  | 2012-03-28 00:00:00 | 2012-03-27 00:00:00 | 2012-05-08 00:00:00 |  | 2012-05-08 00:00:00 |  | 2012-05-07 00:00:00 |  |  |  | 2012-05-07 00:00:00 |  | No Facilities available.  Small Project 38 days to build facilities. OSPE PROJECT 8664027 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-17 00:00:00