Vlookup Tables Jobs

3 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Hourly - Entry Level ($) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
We need an Excel expert to cleanse our customer database (100,000+ entries) and run v lookups across a 3 sheets, carefully extracting the key data to be merged with a mastersheet. It will be a 3-4 hour job for the right person. If you have the skills below please send your application through. Key skills: - Data extraction and excel expert - Experienced in using v lookup - Track record of successfully completing similar tasks - Careful worker with good common sense - Excellent communicator
Skills: VLookup Tables database management Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 30+ hrs/week - Posted
JOB DESCRIPTION The person applying should have prior experience working with large set of data since most of the files will have five to thirty thousands of rows. The person should be comfortable with function like vlookup, hlookup, filter, conditional formatting, delete double, advanced copy paste (verticaly to horizontaly, data only...), formula to copy several text cell to one text cell (ex: Column1&Column2&"text1"&(if(Column3=yes),Column4,blank)... ) If you know excel macro, you will be able to save a lot of time. For Most of our customers you will need to work on the excel documents and upload it into their backoffice. Also we have one large retailers, that need manual dataentry. Means you will be better with 2 screens, and you will do a lot of copy paste to add manually each products Key Responsibilities: - Candidates with a strong inclination towards numbers, excel spreadsheets, formulae, queries and software applications - Must have Excel, not google sheets - Strong Excel Skills - Ability to format and transfer the information from one excel document to another excel document that have similar column field but different format - Basic SEO Understanding - Good english Writing Ability - Researching - Internet Speed – Screen shot (need to download sometimes a lot of large images) - Review data for deficiencies or errors, correct and incompatibilities if possible and check output Time We added new products every weeks, so the job will be all the times. We have freelancer from Odesk that work directly with our company since 4 years (wayfair, walmart, overstock, groupon, staples, amazon, ebay ...) If you have experience with one of the retailers listed above, it will be a real plus for your application (send me screenshot of retailers backoffice in this case) . Please send us experience, similar job experience, screenshot of different excel document that you worked with... Thanks
  • Number of freelancers needed: 2
Skills: VLookup Tables Data Entry Microsoft Excel