Suodata

Viimeisimmät hakuni
Suodatusperuste:
Budjetti
asti
asti
asti
Tyyppi
Taidot
Kielet
    Työn tila
    1,102 Vlookup työtä löytyi, hinnoittelu EUR

    Hey I need a spread sheet with financial records, it has to contain a Vlookup, charts and some numeric operations. If anyone would like to give it a go please let me know.

    €21 (Avg Bid)
    €21 Keskimäär. tarjous
    7 tarjoukset

    ...you qualify, see samples of formulas below: 1) =IF(EXACT(RIGHT(F2,1),"s"),"have",IF(EXACT(RIGHT(F2,1),"s "),"have","has")) 2) =IF(ISERROR(MATCH(A1,C:C, 0)), "No Match", VLOOKUP(A1,C:C,2,FALSE)) 3) =INDEX({"Black","Blue","Green","Gray","White","Black/Blue","Blue/B...

    €4 / hr (Avg Bid)
    €4 / hr Keskimäär. tarjous
    23 tarjoukset
    Excel VBA VLookup - Running too slow 4 päivää left
    VARMENNETTU

    I have a project with Excel vba vlookup that needs modified. The tables are large and the vlookup is very slow. When I read documentation, the suggestion is to use a double vlookup, which I am not able to get the syntax right,. This is the line that is working, but slow: LookupResult = [kirjaudu nähdäksesi URL:n](LookupValue, LookupRange

    €95 (Avg Bid)
    €95 Keskimäär. tarjous
    31 tarjoukset
    Project for Akila K. 7 päivää left

    I have a project with Excel vba vlookup that needs modified. The tables are large and the vlookup is very slow. When I read documentation, the suggestion is to use a double vlookup, which I am not able to get the syntax right,. This is the line that is working, but slow: LookupResult = [kirjaudu nähdäksesi URL:n](LookupValue, LookupRange

    €22 / hr (Avg Bid)
    €22 / hr Keskimäär. tarjous
    1 tarjoukset

    ...list. and then to import excel files contain a large list of companies and in case one of the companies were inputted in the before it showed show as red flag. (More like a vlookup table) So, we will have two interfaces [Back-end] The ability to create multiple lists that contain three columns name of the company, registration number & Comments. [Front

    €150 (Avg Bid)
    €150 Keskimäär. tarjous
    20 tarjoukset
    Excel Project 2 päivää left

    (Datasets can be pulled from https://qwiexplore...the State's earnings? I don't understand PowerPivot and I can't tell you what you need to do about it, you know better :) In the tables please include mean, median, stdev, vlookup, conditional formatting, logical operators if, true/false, MAX, MIN, percentage, line trending, bar chart or column chart

    €34 (Avg Bid)
    €34 Keskimäär. tarjous
    8 tarjoukset

    ...list. and then to import excel files contain a large list of companies and in case one of the companies were inputted in the before it showed show as red flag. (More like a vlookup table) So, we will have two interfaces [Back-end] The ability to create multiple lists that contain three columns name of the company, registration number & Comments.

    €120 (Avg Bid)
    €120 Keskimäär. tarjous
    30 tarjoukset

    Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when running

    €32 (Avg Bid)
    €32 Keskimäär. tarjous
    21 tarjoukset
    HR generalist Loppunut left

    Vlookup ,pivot table

    €14 (Avg Bid)
    €14 Keskimäär. tarjous
    5 tarjoukset

    I have two lists that need to be merged together so I can compare the data in them. The common reference field is the part number. I've been trying to merge using Vlookup and having problems since this is new to me. Hoping for a quick solution and then maybe I have some more data to manipulate

    €15 (Avg Bid)
    €15 Keskimäär. tarjous
    20 tarjoukset

    Hi Freela...your help. I am able to export my pricelist as a CSV. I have about 600 SKUs that need to be updated in my main cost sell guide. Essentially I need a way to search (maybe VLOOKUP) the CSV file and find a match in the Cost Sell Guide and to rewrite the corresponding cells with the updated cost sell pricing. This should be straight forward.

    €54 (Avg Bid)
    €54 Keskimäär. tarjous
    28 tarjoukset

    Spreadsheet Number 1. I have the sheet set up but I my OFFSET formula is not working correctly. The spreadsheet has a master sheet that collects data into one sheet that is easily analyzed. The bulk of the data is pulled straight from the one worksheet but I need to be able to pull in every other row for one data set - then I need to pull in the same row for data that matches the dates on the r...

    €17 / hr (Avg Bid)
    €17 / hr Keskimäär. tarjous
    19 tarjoukset

    [kirjaudu nähdäksesi URL:n] See row 1125. =VLOOKUP(C1127,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1gPliCjcMCiKItp_uHIEQUvU7fbrt8_HZmYCIgSK9954/edit#gid=1037904971","ORDERS!A3:Y2539"),25,0) Need help formatting my formula.

    €18 (Avg Bid)
    €18 Keskimäär. tarjous
    9 tarjoukset
    vlookup for me Loppunut left

    need to find name in one spreadsheet and move values associated with that nme to a second spreadsheet and match them to the same name.

    €16 (Avg Bid)
    €16 Keskimäär. tarjous
    11 tarjoukset

    ...of the selected item in Column 3 are to be displayed in the dropdown menu Column 5: An auto-generated field dependent on the selection in Column 4. Similar to performing a VLOOKUP or INDEX/MATCH in Excel Column 6: Same as Column 1 i.e user entered value or pasted from clipboard. I have implemented all of this in excel which I can demonstrate either

    €118 (Avg Bid)
    €118 Keskimäär. tarjous
    39 tarjoukset
    Excel VLOOKUP help Loppunut left

    I have a spreadsheet that needs to match data and return a minimum value in another column. SO column B3 needs to be matched and column B4 needs to be matched and the minimum total value needs to be returned

    €15 (Avg Bid)
    €15 Keskimäär. tarjous
    7 tarjoukset

    Make Station Through vlookup in excel.

    €206 (Avg Bid)
    €206 Keskimäär. tarjous
    5 tarjoukset

    ...Excel Solver. Please see the attached for reference, there are 10 input variables (Rows 2-11) and 10 output variables (Rows 138-147). The input is subjected to 1 initial Vlookup (Rows 37-51) and 3 Multiplier matrices (Rows 66-75, 90-99 & 114-123). Our aim is to adjust the Multiplers (Highlighted in Yellow) and format of the formulas/workings to have

    €57 (Avg Bid)
    €57 Keskimäär. tarjous
    9 tarjoukset

    ...Excel Solver. Please see the attached for reference, there are 10 input variables (Rows 2-11) and 10 output variables (Rows 138-147). The input is subjected to 1 initial Vlookup (Rows 37-51) and 3 Multiplier matrices (Rows 66-75, 90-99 & 114-123). Our aim is to adjust the Multiplers (Highlighted in Yellow) and format of the formulas/workings to have

    €49 (Avg Bid)
    €49 Keskimäär. tarjous
    4 tarjoukset

    I have some work, in an Excel spreadsheet.

    €20 (Avg Bid)
    €20 Keskimäär. tarjous
    53 tarjoukset

    ...formulaes accordingly. We have some rules, each formula should refer to a table and column. We have two kinds of tables - with ID and without. With ID we do not need to use the VLOOKUP formulae since this is automaticly in the tool (1), just use: VALUE(TABLE(COLUMN) for numbers and CONCATENATE for text in the formulae. (2) IF there is no ID we use the index

    €103 (Avg Bid)
    €103 Keskimäär. tarjous
    18 tarjoukset

    ...Excel Solver. Please see the attached for reference, there are 10 input variables (Rows 2-11) and 10 output variables (Rows 138-147). The input is subjected to 1 initial Vlookup (Rows 37-51) and 3 Multiplier matrices (Rows 66-75, 90-99 & 114-123). Our aim is to adjust the Multiplers (Highlighted in Yellow) and format of the formulas/workings to have

    €127 (Avg Bid)
    €127 Keskimäär. tarjous
    24 tarjoukset
    I need help Loppunut left

    In cell J3, use a VLOOKUP function to determine the discount earned based on the cost of trip and the data on the Agency Data and Analysis worksheet. Format as Percentage with 1 decimal place.

    €10 / hr (Avg Bid)
    €10 / hr Keskimäär. tarjous
    14 tarjoukset

    We are hiring a talented freelancer to complete a quick excel project that requires knowledge of its advanced functions. Candidate MUST have knowledge of functions such as VLOOKUP, SUMIFS, AVERAGEIFS, COUNTIFS, SUBTOTAL, INDEX, MATCH etc. Must be completed ASAP

    €22 (Avg Bid)
    €22 Keskimäär. tarjous
    19 tarjoukset

    create macro for data manipulation. the macro should have 3 buttons which are able to execute automatically some vlookup functions.

    €104 (Avg Bid)
    €104 Keskimäär. tarjous
    56 tarjoukset

    I need to Vlookup data from different google sheets.

    €19 (Avg Bid)
    €19 Keskimäär. tarjous
    34 tarjoukset

    Hello - I have a simple contest for Excel Masters for a spreadsheet: Period Flow thru Worksheet: Criteria 1: Column I “Actual”: Match (sumifs) column C with “Sales Tab” column b “restaurant_id” Criteria 2: sales tab “business date” (column C) with calendar tab “date” (column A) Criteria 3: Period Flow Thru Worksheet row 3 Period...

    €27 (Avg Bid)
    Taattu
    €27
    7 työtä

    ...provide some context, we would be looking for someone to help clean up our marketing database. At present we have carried out any company name standardisation by a large vlookup table. Any new raw names are first checked against this to see if we have come across them previously. If not, we then try to apply fuzzy logic to assign them to previously

    €14 / hr (Avg Bid)
    €14 / hr Keskimäär. tarjous
    40 tarjoukset

    ...project is about Virtual assistance, data entry, web research, web monitoring, etc. You need: - Very Good excel skills (especially knowledge of shortkeys and functions like vlookup) - Good internet connection - Latest version of MS Office (preferred) - Full time availability (preferred) - Ability to learn work processes for the first 1-2 months (You'll

    €3 / hr (Avg Bid)
    €3 / hr Keskimäär. tarjous
    7 tarjoukset

    ...I'm in the US. I need to match that against a suppression list of just email addresses, which amount to 80k approx. What I need is clear instruction, perhaps a written vlookup formula that would see if 80k email addresses also are in the large database and remove them, with those blank rows replaced. Your written instructions for me can be in Word

    €22 (Avg Bid)
    €22 Keskimäär. tarjous
    10 tarjoukset

    “Advanced in MS Excel including PivotTables, VLOOKUP, INDEX/MATCH, and Data Tables”. Work station needed.

    €919 (Avg Bid)
    €919 Keskimäär. tarjous
    38 tarjoukset

    Dear Programmers, What I need is to make a custom pr...what I need is that , when we open the program it asks me to choose the destionation of the excel file, then asks me what kind of product will be in client day, then does Vlookup, then copy and past the result (but only specified columns) to new sheet and etc.. please only professionals reply.

    €123 (Avg Bid)
    €123 Keskimäär. tarjous
    35 tarjoukset

    I need help with statistics and excel for my business. You have to be experienced wi...You have to be experienced with using excel to solve linear regression, statistics, and blackbox influence diagrams. You will also need to be experienced with data tables, vlookup, solver, and probability. I need this completed in 1 day. I will pay extra for this.

    €101 (Avg Bid)
    €101 Keskimäär. tarjous
    36 tarjoukset

    ...communicate that without hesitation. You love creating SOPs (Standard Operating Procedure) templates to make our systems repeatable Excel & Spreadsheets excite you. When you hear VLOOKUP, you do a happy dance. And if you don't know how to do it, you're hopping on YouTube or popping into a forum to figure it out in a jiffy. If you feel like you are a good

    €10 / hr (Avg Bid)
    €10 / hr Keskimäär. tarjous
    8 tarjoukset

     “Advanced in MS Excel including PivotTables, VLOOKUP, INDEX/MATCH, and Data Tables”.Work station needed.

    €860 (Avg Bid)
    €860 Keskimäär. tarjous
    40 tarjoukset

    ...placeholders. Here is the basic outline of the project: 1. select column A (SKU) value which will be a drop down with Data Validation 2. column B, E, G will use a vlookup to fill in the default values 3. column C, D, F values will be typed in by the user 4. macro button (not displayed) to run a command for all items in column (E) = straight

    €96 (Avg Bid)
    €96 Keskimäär. tarjous
    22 tarjoukset

    vlookup program macro as discussed in chat

    €221 (Avg Bid)
    €221 Keskimäär. tarjous
    1 tarjoukset

    Hello my name is mike and I would like your assistance with a project requiring formulas, 3D charts, VLookup formulas and other advanced excel tasks

    €108 (Avg Bid)
    €108 Keskimäär. tarjous
    26 tarjoukset

    Hello my name is mike and I would like your assistance with an excel project requiring formulas, 3D charts, VLookup formulas and other advanced excel tasks

    €9 (Avg Bid)
    €9 Keskimäär. tarjous
    1 tarjoukset

    Hello my name is mike and I would like your assistance with a project requiring formulas, 3D charts, VLookup formulas and other advanced excel tasks

    €27 (Avg Bid)
    €27 Keskimäär. tarjous
    1 tarjoukset

    Hello. I have two excel sheet with different value but the code are same so i want someone to use vlookup function and put the accurate match [kirjaudu nähdäksesi URL:n] details on PM

    €4 / hr (Avg Bid)
    €4 / hr Keskimäär. tarjous
    5 tarjoukset

    ...| company | position | email * Step 3: Get the emails by comparing to KNOWN email structures (ie. jsmith@[kirjaudu nähdäksesi URL:n]). (I have a list you can compare them to, using vlookup or other functions. ***Must have linkedin sales navigator to find candidates*** Must be able to create script using programming language to extract data *** (we will be

    €10 / hr (Avg Bid)
    €10 / hr Keskimäär. tarjous
    20 tarjoukset

    We have created an excel file with Macro and VLookup that works fine in Windows but when opened on a Mac some of the features don't work. Either nothing happens or errors appear when we click buttons. We want someone to covert the code to be readable by both Windows Excel and Mac Excel

    €71 (Avg Bid)
    €71 Keskimäär. tarjous
    8 tarjoukset

    We have a dashboard that holds some sensitive data on the backend, I need this data to be moved into a seperate workbook and a series on vlookup / Importrange formulas created to make the sheet read from the data workbook. NO more than 10 formula

    €19 (Avg Bid)
    €19 Keskimäär. tarjous
    5 tarjoukset

    ...merged to 1 csv file 3. perform vlookup kind of function to assign values 3.a. I have a master file (csv) which contains full name, code1, code 2 and code 3 3.b. in consolidated file 1 column will have full name, do a vlookup and get corresponding code1, code2, code3 from master csv file 3.c. append the vlookup results on each row end 4.

    €21 (Avg Bid)
    €21 Keskimäär. tarjous
    14 tarjoukset
    Do some data entry Loppunut left

    I have some work, in an Excel spreadsheet. Vlookup Hlookup Pivot analytics Data representation Formulas and

    €94 (Avg Bid)
    €94 Keskimäär. tarjous
    55 tarjoukset

    I need a wordpress plugin that requires first of all users to sign in so that they are assigned to their login specific page intended for them. Plugin is more or less a calculator where it reads in data from a spreadsheet that is not accessible by the user. The page where the calculator is shown to the user is protected and code cannot be copied. The plugin need to have a admin page were it�...

    €206 (Avg Bid)
    €206 Keskimäär. tarjous
    10 tarjoukset

    ...on Functions with Examples, seperate short video for each --> Explain what the function does, and when & why it is used; Seperate video for popular functions like Count, Vlookup, Hlookup) i) Financial ii) Date & Time iii) Math & Trig iv) Statistical v) Lookup & Reference vi) Database vii) Text viii) Logical ix) Information x) Engineering xi) Cube

    €321 (Avg Bid)
    €321 Keskimäär. tarjous
    17 tarjoukset
    Data Manipulation Loppunut left

    I have 2 lists with common Columns that need to be merged (VLOOKUP). The second tab has some format issues and some cells need to be split and seperated into individual columns. This should be a pretty easy job.

    €45 (Avg Bid)
    €45 Keskimäär. tarjous
    16 tarjoukset

    ...calculate approximate values for a range from all columns in the worksheet for approx. 100 individual Excel worksheets and then transfer them to a mastersheet. Furthermore, via VLOOKUP or similar. Data is read from a sheet and read into another mastersheet. If successful, a follow-up project exists in the next 2 weeks. Data is transferred via wetransfer;

    €20 (Avg Bid)
    €20 Keskimäär. tarjous
    14 tarjoukset

    Suosituimmat Vlookup -yhteisöartikkelit