En curso

CSV Help with VLookup and Array

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.

Habilidades: Entrada de datos, Procesamiento de datos, Ingeniería, Excel, PHP

Ver más: i need help with excel, find reps, csv codes, vlookup table, need help with excel, find a sales rep, Vlookup, i need sales reps, i need a sales rep, find sales rep, excel vlookup, php table array, php table csv, import excel array, excel array, php excel array, table csv, php excel php array, csv table, cross reference excel, csv array php, import data excel sheet, codes csv, excel sales sheets, match columns excel

Información del empleador:
( 45 comentarios ) Whittier, United States

ID de proyecto: #4979807

Adjudicado a:

mandeeps207

Hi there, lets start asap.....regards

$5 USD / hora
(38 comentarios)
4.6

3 freelancers están ofertando un promedio de $5 /hora para este trabajo.

datasolutionind

Let's Start.........

$5 USD / hora
(40 comentarios)
4.8
dobreiiita

Happy to help you out.... experienced in handling large excel files....

$5 USD / hora
(33 comentarios)
4.8