I have a CSV is that is not VLooking up information properly. The attached Excel sheet has 4 sheets: Main Table Sheet, Aug Sales, Reps and Zips, and States. The main sheet that is very important is "Main Table Sheet". On that sheet you see 4 columns for Month, Zip Code, Sales Amount and Customer. The problem is I need to be able to find two more columns of information to import into "Main Table Sheet". The two fields I need added are "Sales Rep", this is available in she "Reps and Zips" that use a number identifier (ex. 1,2,3,4,5,6,7,8) to match up to zip codes. "Reps and Zips" sheet already has the zip codes, states, and Rep Code itemized there. The final Look Up I need is on "Main Table Sheet". You will see Zip Codes in Column 2. I need you to cross reference them in that Sheets "states" and "reps and zips" to display the state after the "sales rep" in previous task.
That is all. Please see attached CSV. Need this done today.