Data Scrub

Directions I am looking for someone that can complete our project in 12 hours (Please do not bid on this project unless you are 100% you can complete it by 3:00am (Pacific Standard Time, California Time) Please complete a couple of examples for me so I am able to check for accuracy and I can award the project right away. Project Details: 1. You will be working with two spreadsheets a. Spreadsheet Top 200_9302015 (For reference) b. Spreadsheet VOIP_Inovation 9302015 (plug in data) 2. The data will be plugged into excel spreadsheet VOIP_Inovation 9302015, referencing data from excel spreadsheet Top 200_9302015. 3. First, you will search for the city and state on spreadsheet Top 2000_9302015 that corresponds to City and state on spreadsheet VOIP_Inovation 9302015 spreadsheet. 4. You will then use columns A (US POPULATION RANK), B (City), C (State) on spreadsheet Top 200_9302015 which need to match up with columns D & I on spreadsheet VOIP_Inovation 9302015 5. Then once you match up the city and state you will then plug into columns A (US POPULATION RANK), B (City), C (State) on excel spreadsheet named VOIP_Inovation 9302015 6. Please see my examples on spreadsheet named VOIP_Inovation 9302015 highlighted in Yellow. a. Please be advised that both City and State columns need to match on both spreadsheets in order to plug in data onto spreadsheet VOIP_Inovation 9302015 from spreadsheet named Top 200_9302015 b. Please be aware that you will find duplicate city and states on spreadsheet named VOIP_Inovation 9302015, make sure you plug in the corresponding data to each of the columns like I show in my examples in yellow c. If you can't find a city and state that correspond please use N/A in the cells, like I show in my examples.