Фильтр

Мои последние поисковые запросы
Фильтровать по:
Бюджет
по
по
по
Тип
Навыки
Языки
    Статус работы
    1,267 vlookup работ(-а,-ы) найдено, цены указаны в USD
    Complex data entry 14 часов(-а) left

    Full time (40-60 hours a week) workers needed. Proficiency in: - Excel (some minor scripts like Vlookup) - Google sheets - Amazon seller central - [войдите, чтобы посмотреть URL] Product page Please see attached file for an outline of steps. Best with prior experience working for an amazon seller. Best if you can work during New York USA working hours.

    $4 / hr (Avg Bid)
    $4 / hr Ср. ставка
    24 ставки
    Vlookup Product ID Завершено left

    I have some work, in an Excel spreadsheet. I need a vlookup done to populate a blank column in sheet 1 with values from sheet 2 where there are matching in both sheets.

    $19 (Avg Bid)
    $19 Ср. ставка
    43 ставки
    Excel - Fix VLOOKUP function error Завершено left

    We are looking for someone with very good excel skills to fix a VLOOKUP formula that is returning errors for a small % of lines of data in our table. #N/A Did not find value 'XYZ' in VLOOKUP Evaluation

    $17 (Avg Bid)
    $17 Ср. ставка
    12 ставки

    Note: you must have a comprehensive English word list to do this project. We have a list of ~108K of 4 and 5 letter words that may or may not be an English word. You must have an comprehensive database of English words to check against. (we do NOT have a database). We want the words in our list flagged in an Excel sheet. At the end of the project we want (1) our list flagged and (2) the DB of Eng...

    $18 / hr (Avg Bid)
    $18 / hr Ср. ставка
    6 ставки
    MULTIPLE VLOOKUP IN ONE FORMULA Завершено left

    I need someone to assist and fix my formula quickly, it a simple iferror vlookup formula in google sheet.

    $17 (Avg Bid)
    $17 Ср. ставка
    21 ставки
    Simple VLOOKUP Excel Project Завершено left

    Excel sheet contain to tables, each one has (user input) and (result) highlighted with example USING ONLY VLOOKUP Function: 1st Table = User input in cell E3 and the result will show in cell F3 2st Table = User input in cell J3 and the result will show in cell M3 attached is the file i hope it's clear enough

    $17 (Avg Bid)
    $17 Ср. ставка
    11 ставки
    Vlookup Macro Завершено left

    hi, i have two workbooks with common data and i need to create a macro to combine them into one workbook, add additional sheets, rename them, and complete a vlookup

    $21 (Avg Bid)
    $21 Ср. ставка
    10 ставки
    i need excel formula assistance Завершено left

    I have 2 formulas I need to create. Either a vlookup or a sumifs. Then i have to do a trailing 4 week average and then figure out the correlation between the 2 averages. Column D in the "sales" tab. I have to pick up the amount from the first tab in Column H. Then on Column AU find the 4 week trailing average and then get the correlation between entrees and sales in Column AW

    $33 (Avg Bid)
    $33 Ср. ставка
    5 ставки

    1) Converting Excel files to MS Access database as above; 2) providing analysis & Reporting in Access & 3) training staff to do 2) Require 1 day a week to be on-site in Section 7, shah alam for a tenure of 6 months

    $1915 (Avg Bid)
    $1915 Ср. ставка
    21 ставки

    Looking for an excel /Android app to be created for ordering food perishables in a fast food restaurant. Process flow as follows: Input: 1. Enter 'date': ddmmyy (max 7 dates) 2. Enter number of persons: 3. Enter number of staff: 4. Select 'time of day' for each date from droplist: breakfast, lunch, tea, dinner, snacks 5. Select any 4 'recipes' from droplist for eac...

    $34 (Avg Bid)
    $34 Ср. ставка
    22 ставки

    I need an excel VBA champion who can understand business requirements quickly and deliver top class work on short notice. Need a person with atleast 30+ project delivered using VBA. Please explain on a scale of 0-5 your expertise in each of the following areas : How Familiar are you with VLOOKUP? How Familiar are you with PivotTables? How Familiar are you with VB (Macro) in excel? Excel Forms:...

    $148 (Avg Bid)
    $148 Ср. ставка
    10 ставки
    Excel mailing list clean up Завершено left

    We use MS Excel for our Mailchimp newsletter and we had 100's of emails that bounced back with our 1st newsletter last week, so the list needs to be updated. We received 2 types of bounced backs, hard and soft. The hard ones need to be deleted and the soft ones need to be added to a new sheet on the same workbook. With the vlookup feature in excel this should be a simple project for someone f...

    $83 (Avg Bid)
    $83 Ср. ставка
    13 ставки
    Fix my excel formulas Завершено left

    Hi there, I have two formulas that dont seem to be totalling my data correctly, I just need some help fine tuning them and making sure the totals match. Really should take long, just my head is sore and want this report finished today :) =SUMIF('DETAIL DATA'!C:N,C9,'DETAIL DATA'!K:K) =SUMPRODUCT(VLOOKUP(C9,'DETAIL DATA'!$C$6:$AI$139,{19,20,21},0)). I have attached...

    $17 (Avg Bid)
    $17 Ср. ставка
    16 ставки

    In have a workbook with just 2 tabs. on tab 1 i have a long list (300K rows) and on tab 2 I have a long list (150K rows). I need to lookup the values in column A on tab 2 against column A in tab 1 and then show the value in column B but i have cases where i have more than 1 match in column A and i need to see all of the matches together on tab 2. so I have this formula which works 100% perfect =T...

    $32 / hr (Avg Bid)
    $32 / hr Ср. ставка
    42 ставки
    I need an excel expert Завершено left

    vlookup-I need the names to show the employee id of employees who completed thier preventative exam

    $30 (Avg Bid)
    $30 Ср. ставка
    2 ставки
    Lonh Term Proofreading Project Завершено left

    Note: you must have a *comprehensive* English word list to do this project. We have a list of ~108K of 4 and 5 letter words that may or may not be an English word. You must have an comprehensive database of English words to check against. (we do NOT have a database). We want the words in our list flagged in an Excel sheet. At the end of the project we want (1) our list flagged and (2) the DB of E...

    $15 / hr (Avg Bid)
    $15 / hr Ср. ставка
    24 ставки
    Data Entry/Proofreading Project Завершено left

    Note: you must have a *comprehensive* English word list to do this project. We have a list of ~108K of 4 and 5 letter words that may or may not be an English word. You must have an comprehensive database of English words to check against. (we do NOT have a database). We want the words in our list flagged in an Excel sheet. At the end of the project we want (1) our list flagged and (2) the DB of E...

    $15 / hr (Avg Bid)
    $15 / hr Ср. ставка
    28 ставки
    Pdf To Excel Data Entry Work Завершено left

    I know Very Well Excel Data Entry Work Vlookup,sumif,Hlookup, Pdf To Excel Date Entry Work

    $310 (Avg Bid)
    $310 Ср. ставка
    21 ставки

    Excel work, sumif, countif, sumifs, countifs, pivot, vlookup, hlookup, index, match, condition format

    $1 / hr (Avg Bid)
    $1 / hr Ср. ставка
    1 ставки

    Note: you must have a comprehensive English word list to do this project. We have a list of ~108K of 4 and 5 letter words that may or may not be an English word. You must have an comprehensive database of English words to check against. (we do NOT have a database). We want the words in our list flagged in an Excel sheet. At the end of the project we want (1) our list flagged and (2) the DB of Eng...

    $18 / hr (Avg Bid)
    $18 / hr Ср. ставка
    16 ставки

    Note: you must have a *comprehensive* English word list to do this project. We have a list of ~108K of 4 and 5 letter words that may or may not be an English word. You must have an comprehensive database of English words to check against. (we do NOT have a database). We want the words in our list flagged in an Excel sheet. At the end of the project we want (1) our list flagged and (2) the DB of...

    $111 (Avg Bid)
    $111 Ср. ставка
    19 ставки

    I need a excel automation which has function below: 1. When I input a product item no., it automatic map the product name 2. After I input all the quantity, it automatically make a purchase order 3. After the purchase order is made, it automatically make a invoice 4. The excel allow me to add/change the customer name, address, contact person etc....and also allow me to change the price...

    $451 (Avg Bid)
    Соглашение о неразглашении
    $451 Ср. ставка
    52 ставки
    Simple VBA Excel Project Завершено left

    need to create code such as (vlookup, sum ) using ready database STEPS: User input manual in COL "P" ROW "2" and click enter Break down letters using VBA (in background or hidden cells) Assign number for each letter using VBA DATABASE ( such as vlookup ) (in background or hidden cells) Sum total number as result on COL "N" ROW "2" example: user input ...

    $25 (Avg Bid)
    $25 Ср. ставка
    8 ставки

    I like to get rate value for city based on different rate brackets from another sheet. Example : Rate for Sudbury from Brampton if the weight is between 500-1000 lbs and rate if the weight is between 1000-2000 and so on ,I have file ready with me. In cell Q2 (CTT Rate) I need rate for Sudbury (J2) from rate sheet "CTT 6 LBS Rate, for the order weighing 517.00 lbs. Currently under CT...

    $19 (Avg Bid)
    $19 Ср. ставка
    6 ставки
    powerapps data Завершено left

    hi, i want a powerapp connected to my excel file. nowdays i have 2 excel tables. (stored in 1 excel file in onedrive) 1 with Item - S/N - Uniqnumber - And 1 with User-Mail-S/N - Uniqnumber that are connected to the other table via VLookup. want to be able to view that in one powerapp so i dont need to open excel everytime. and if possible add new items or User and enter what item that user has.

    $51 (Avg Bid)
    $51 Ср. ставка
    9 ставки
    E-Commerce Manager Завершено left

    E commerce strategy implementation : Achieve business plan targets to contribute to the top line & channel margins. Understand e-commerce partner's key business drivers. - Account Management: Manage key account for the assigned e commerce partner end to end. Align with the e-commerce partners & prepare a joint business plan approach. - Stock Planing & Inventory Management: Week wi...

    $343 (Avg Bid)
    $343 Ср. ставка
    11 ставки

    Hello, I have an excel file that already completes using vlookup and the pivot table. I'm a little messy with the excel formula. Please help with this 5min job.

    $13 (Avg Bid)
    $13 Ср. ставка
    59 ставки
    Merge Excel databases Завершено left

    I have two Excel worksheets. One has a list of Accounts and ID's - the other has Accounts with Items. I want to add the Account ID's to the sheet with the Accounts with Items. It is not a huge project but needs to be done TODAY - Cannot figure out vLookup, Match, etc. Need an excel whiz to draw up a formula for me and I can then implement it as the data is proprietary on the sheets...

    $20 (Avg Bid)
    $20 Ср. ставка
    18 ставки

    I need to replace country values in one sheet (United States, India, etc) with region values (North America, IMEA(India, Middle East, Afirca), etc). I have the lookup table ready, I just cant get the formula right.

    $19 (Avg Bid)
    $19 Ср. ставка
    11 ставки
    Programar Planilla Google Завершено left

    Realizar vistas en pestañas combinando formulas VLOOKUP, Index con MATCH para ver datos filtrados en tiempo real.

    $20 (Avg Bid)
    $20 Ср. ставка
    6 ставки

    Hi, we have 338 product names of beverages. The task is to look up the beverages' names in an Excel file and copy the product number. This cannot be done with vlookup as the beverages' names don't match exactly. We'll provide to Excel files: 1) 338 Product names 2) List with all product names and number Thanks.

    $25 (Avg Bid)
    $25 Ср. ставка
    78 ставки

    1 B10 - Auto text filter (Contains text) for table 'TEST' column 'Article' based on text within this cell 2 C10 - Auto text filter (Contains text) for table 'TEST' column 'Description' based on text within this cell 3 "+" button add a row above the cell which contains the SUM formula in this case it is "D8", the new added row contains t...

    $24 (Avg Bid)
    $24 Ср. ставка
    4 ставки

    I would like to create a google sheet that can compile information from various sheets. This information is for horse racing selections I have included a screen shot to show how the information will be formatted. *** Please read the steps below and respond with the following answers*** Have you completed a similar task to this? If so how? Have you ever done work with horse racing? Are you compe...

    $105 (Avg Bid)
    $105 Ср. ставка
    19 ставки
    VLOOKUP/ COLUMNS MERGE DATA Завершено left

    I need to retrieve data from one sheet to another with certain columns. Information on sheet "leads" I need to pull columns O-T to sheet "V2" and have them match with the key id column information

    $22 (Avg Bid)
    $22 Ср. ставка
    19 ставки
    Vlookup Project Завершено left

    I have 2 spreadsheets. One master and One with a list of TIN's. I need to match all TIN's from the TIN list to the master spreadsheet so I can make edits to those lines.

    $18 (Avg Bid)
    $18 Ср. ставка
    8 ставки

    I need to calculate average formula problem is if sheet is blank or zero i do not want to include in average u can see sample file =AVERAGE(VLOOKUP(A4,'day1'!$A$1:$C$6,3,0),VLOOKUP(A4,'day2'!$A$1:$C$6,3,0),VLOOKUP(A4,'day3'!$A$1:$C$6,3,0))

    $12 (Avg Bid)
    $12 Ср. ставка
    23 ставки

    I need you to fill in a spreadsheet with data.

    $3 / hr (Avg Bid)
    $3 / hr Ср. ставка
    28 ставки

    Hi I Need help running a formula for an excel file. Most likely VLOOKUP Formlua Should not take more than 5 mins for an experienced individual I need to fill column I and J Data is going to match rows from column E against Column A Excel File is attached Regards,

    $10 (Avg Bid)
    $10 Ср. ставка
    14 ставки
    Excel Sheet Help Завершено left

    I am trying to get an Excel sheet to formulate my sheet as per my requirement and having difficulty with nested vlookup function. Immediate help would be appreciated and the work shall be no less than 30 mins

    $13 (Avg Bid)
    $13 Ср. ставка
    40 ставки
    Web Scraping from one web site. Завершено left

    Hi, I need help to scrape price data from the web and dump it on google sheets. The dump should have up to 4 fields: 1) name of product, 2) price, 3) additional detail (only in certain cases) 4) potentially the category of that product (e.g.: beverage, grocery etc). I’ll fetch the prices using a “vlookup” or similar method, so ideally the string names won’t change. W...

    $22 (Avg Bid)
    $22 Ср. ставка
    22 ставки
    FREIGH SHEET Завершено left

    WE WILL BE WORKING WITH 4 SHEETS IN AN [войдите, чтобы посмотреть URL] MASTER SHEET(7000 ENTRIES) AND 3 SUPPORTING [войдите, чтобы посмотреть URL] SHEET WILL BE TAKING DATA FROM SUPPORTING SHEET(BY VLOOKUP AND ROUNDUP)

    $89 (Avg Bid)
    $89 Ср. ставка
    41 ставки
    help complete excel build template Завершено left

    custom written excel program to build product with width, height and depth input program yields complete build data for Art system. Two sections section 1 input data with Data validation, and Vlookup. section 2 is data out put for manufacturing.

    $414 (Avg Bid)
    $414 Ср. ставка
    24 ставки

    We are using Google Spreadsheet as a project management tool and it became UNBEARINGLY SLOW to work with. There are around 15 people working on it simultaneously and this is wasting a lot of time. The spreadsheet: - has around 100 columns and 3000 lines of data - contains project data like IDs, names, dates, sums, some fairly simple formulas (if, iferror, vlookup, round) - has sheets with pivot...

    $1101 (Avg Bid)
    $1101 Ср. ставка
    56 ставки
    access / excel database Завершено left

    Hello , I am trying to create a one to many relationship using several linked excel spreadsheets. I need the excel spreadsheets to be linked as they are updated on a weekly basis. Once the relationships are created I want to combine certain columns from each spreadsheet using a query. Once I have all the information I need on one table I need to import this into excel to create a profit per sa...

    $138 (Avg Bid)
    $138 Ср. ставка
    53 ставки
    Vba macro developer Завершено left

    Created Macros for Business Development. Automating, modifying, and optimizing reports in Excel Access. Experience in the development of financial applications using Excel and Access. Experience in redesigning, maintaining and supporting existing applications and tools especially in Microsoft Excel Access 2007 / 2010. Experience in Advanced Excel and its features like Pivot Tables, Charts, Functio...

    $305 (Avg Bid)
    $305 Ср. ставка
    22 ставки

    I want to create a database with logo (picture) with specific serial number to each logo. Then I want to be able to run some sort of vlookup from another excel and return the logo.

    $21 (Avg Bid)
    $21 Ср. ставка
    10 ставки

    Our company is one of the leading comparison services in Australia, aiming to empower individuals to make better financial decisions. We are looking for a Client Services Support gun to join our team. You will work with our partners to implement end to end tracking solutions for all performance activity on site. This role is heavily focussed on click and conversion tracking, analysing conversion...

    $3 / hr (Avg Bid)
    $3 / hr Ср. ставка
    19 ставки
    Growth Analyst _-Facebook Завершено left

    Growth Analyst in charge of Facebook ad buying strategy, a/b testing and optimizing Google ads spend and ad buys. Responsible for generating profits to grow and scale the paid media account(s) by driving equal or lower costs per customer acquisition while increasing paid media spend on platforms Facebook, Instagram, Google, Pinterest and youtube. Knowledge of executing paid media strategies inclu...

    $494 (Avg Bid)
    $494 Ср. ставка
    12 ставки
    Excel Vlookup Завершено left

    I need to use a vlookup to compare the UPCs in your master list with what is in Retail [войдите, чтобы посмотреть URL] that data I need to compile a new sheet with additional data

    $17 / hr (Avg Bid)
    $17 / hr Ср. ставка
    32 ставки

    Топ-статьи сообщества vlookup