Vlookup Tables Jobs

6 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}})
Fixed-Price - Intermediate ($$) - Est. Budget: $10 - Posted
I am looking for an experienced Excel guru for a quick assignment. I need you to help me create several Excel formulas that connect raw data from one sheet to several existing report templates that I have created. Freelancer must be ready to work immediately and complete the task within 1-2 hours from acceptance. The formulas may include VLOOKUP, IF, arrays, etc. and should not take very long for a contractor with intermediate / expert skills.
Skills: VLookup Tables Excel VBA Mathematics Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $200 - Posted
We are looking for an excel based inventory master file/database. We are a retail business buying stock from multiple suppliers. Ideally we would like to have a masterfile that can track the item, its internal code, its supplier code, description, invoice number, date, category, sub-category, cost price, and retail price along with GP's and markup. Different suppliers will have different invoice formats so we will need the file to remember this and then check arriving prices (cost and retail) against existing. We deal with approx 35 core suppliers but need the flexibility to add an unlimited amount over a period of time as we expand.
Skills: VLookup Tables Excel VBA Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: 1 to 3 months, Less than 10 hrs/week - Posted
Looking for an experienced Data Scientist to help with building out our platform. We currently have an Azure database that collects data about our user base. It charts IP addresses/Name/Date/Score/and a few other juicy pieces of info we'll share when the time is right! We're looking for someone to come in and tell use how best to present this data to our client base to pique their interest to seeing more/subscribing to our monthly feed/export. We want to find new ways to dissect/analyze the data to show added value. Ideally we'd fill in some of the state/city combinations via a data merge from an outside source, as well as tie in duplicate lines to show more than one hit to the site in a creative way! If you're passionate about data analysis, we need your help!
Skills: VLookup Tables Data Analytics Data Science Tableau Software
Fixed-Price - Entry Level ($) - Est. Budget: $300 - Posted
I'm looking to have a program created (or a simpler method if one exists, possibly through VBA) that will allow me to link a column header from one file with the column header of another file. In addition using a value key I would like the value that inputs in the output column to be the product of a lookup (or a vlookup) that is cross referenced off the value key.
Skills: VLookup Tables Excel VBA
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
Skills: VLookup Tables Data Entry Microsoft Excel