I need a person proficient in Microsoft excel to use a formula to check if each of the first 7000 cities on the spreadsheet of the file named "EXEDE serviced cities with Hughesnet data 1-23-13", (in either orange or blue) rows , check against column E of the second file called "Hughesnet top sales cities to see if the city is in that list in column E, and if it is then it needs a "yes" in column "a" of the Exede serviced cites with hughesnet data 1-23-13" file and it needs to then show the sales total from column C of the Hughesnet top sales cities Listed in column B, next to the YES. If its a no, if the city is not in the second file then just have the formula put no in column A instead of yes and nothing in column B. I need this in the next hour. I will pay 30.00 dollars for it. IT MUST BE COMPLETED IN THE NEXT 1 HOUR.
8 freelancers are bidding on average $30 for this job
using formula or vba script sorry It doesn't need proficient excel worker. I am a basic user even I can do this work using VBA script or if formula I think the work may be completed