Need expert help with excel vlookup jobs

Filter

My recent searches
Filter by:
Budget
to
to
to
Type
Skills
Languages
    Job State
    1,103 need expert help with excel vlookup jobs found, pricing in GBP

    I need to come up with a process for conducting a billing audit. I exported data from investment advisor software showing all accounts that were sent an invoice (columns A-D). I then exported data from from the software showing all accounts that had a management fee transaction, proving that the fee was in fact deducted from the account (columns F-I)

    £82 (Avg Bid)
    £82 Avg Bid
    8 bids

    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.

    £19 (Avg Bid)
    £19 Avg Bid
    7 bids

    ...will be working on complex and advanced formulas on Excel files. In time of no Excel projects this person will have enormous responsibility of pining, talking, chatting and managing team of 4-5 people that are coders, developers, designers. QA Manager Position - for someone that is Super Expert at Excel Formulas. Details: Hourly Pay Part Time / Full

    £3 / hr (Avg Bid)
    £3 / hr Avg Bid
    23 bids

    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 = [login to view URL](LookupValue, LookupRange

    £84 (Avg Bid)
    £84 Avg Bid
    32 bids

    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 = [login to view URL](LookupValue, LookupRange

    £20 / hr (Avg Bid)
    £20 / hr Avg Bid
    1 bids

    ...of companies and the primary key is the registration number with the ability to amend the list or create a new 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

    £135 (Avg Bid)
    £135 Avg Bid
    20 bids
    Excel Project 1 day left

    ...make it easier for the freelancer 1. Should U.S. expect earnings increase or decrease in the next decade (2017-2027)? 2. What are three top states with highest earnings? 3. What are the three top states with lowest earnings? 4. By what percent the earnings increased or decreased over 10 years? 5. Between 2018 and 2017, who has earned more, a 50 years

    £31 (Avg Bid)
    £31 Avg Bid
    8 bids

    ...of companies and the primary key is the registration number with the ability to amend the list or create new 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

    £108 (Avg Bid)
    £108 Avg Bid
    30 bids

    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

    £29 (Avg Bid)
    £29 Avg Bid
    21 bids

    Vlookup ,pivot table

    £13 (Avg Bid)
    £13 Avg Bid
    5 bids

    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

    £13 (Avg Bid)
    £13 Avg Bid
    20 bids

    Hi Freelancer, Looking for 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

    £49 (Avg Bid)
    £49 Avg Bid
    28 bids

    ...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 row above but has corresponding data in the row below starting in column Y that needs to pull into the master sheet and the dates need to line up. - EXAMPLE DOC: 11-20-2018 WCHS 51790 REVMAN - need to pull

    £15 / hr (Avg Bid)
    £15 / hr Avg Bid
    19 bids

    [login to view URL] 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.

    £16 (Avg Bid)
    £16 Avg Bid
    9 bids

    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.

    £14 (Avg Bid)
    £14 Avg Bid
    11 bids

    ...treeview and a datagridview to display some data from three tables (Tables 1, 2, 3) from an SQL server database. The tree tables are related to each other using foreign keys with a parent-child relationship. The treeview therefore has three levels of nodes. Expanding a treenode shows the child items under that node. If a user clicks on any of the nodes

    £106 (Avg Bid)
    £106 Avg Bid
    39 bids

    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

    £14 (Avg Bid)
    £14 Avg Bid
    7 bids

    Make Station Through vlookup in excel.

    £185 (Avg Bid)
    £185 Avg Bid
    5 bids

    I have some work, in an Excel spreadsheet.

    £18 (Avg Bid)
    £18 Avg Bid
    53 bids

    ...fomulae in an other application. So we have the following assignment rewrite the excel 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)

    £93 (Avg Bid)
    £93 Avg Bid
    18 bids

    ...spreadsheet that needs to be optimised and verified for the best solution, possibly using 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

    £114 (Avg Bid)
    £114 Avg Bid
    24 bids

    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.

    £9 / hr (Avg Bid)
    £9 / hr Avg Bid
    14 bids

    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

    £20 (Avg Bid)
    £20 Avg Bid
    19 bids

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

    £94 (Avg Bid)
    £94 Avg Bid
    56 bids

    I need to Vlookup data from different google sheets.

    £17 (Avg Bid)
    £17 Avg Bid
    34 bids

    ...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...

    £24 (Avg Bid)
    Guaranteed
    £24
    7 entries

    We are looking for someone to aid with cleaning company names in a database that contains approximately 45,000 unique company names. We have identified several rules that we would like to be able to apply to the work. To provide some context, we would be looking for someone to help clean up our marketing database. At present we have carried out any

    £12 / hr (Avg Bid)
    £12 / hr Avg Bid
    40 bids

    This 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

    £2 / hr (Avg Bid)
    £2 / hr Avg Bid
    7 bids

    ...work, in an Excel spreadsheet... I'm limited to a i3 processor with 8gb RAM. I only have Excel 2010... I need to do the following: One database is approx. 850k rows of two columns of data. Email Address and State. 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...

    £20 (Avg Bid)
    £20 Avg Bid
    10 bids

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

    £826 (Avg Bid)
    £826 Avg Bid
    38 bids

    Dear Programmers, What I need is to make a custom program in excel or in visual basic which will do our manual procedures. we are the company where we make some campaigns and clients day. For example we will have one file (30mb) where the codes , barcodes and etc on there. and what I need is that , when we open the program it asks me to choose the

    £110 (Avg Bid)
    £110 Avg Bid
    35 bids

    I need help with statistics and excel for my business. 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.

    £91 (Avg Bid)
    £91 Avg Bid
    36 bids

    We are a small eCommerce Company looking for someone organized, creative, with a marketing background who is a Ninja! We need help with new exciting projects. Laid back environment where your opinion will be valued. This doesn't require answering the phone or the typical administrative assistant duties that you may be used to. Lots of room for growth

    £9 / hr (Avg Bid)
    £9 / hr Avg Bid
    8 bids

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

    £773 (Avg Bid)
    £773 Avg Bid
    40 bids

    I would like to have excel document coded to export the data from the data entry excel sheet to the corresponsing microsoft publisher template. I would like to fill in an excel sheet then populate multiple Microsoft publisher templates. Each cell in excel would populate to a different template based on information in those cells. I would have a cell

    £87 (Avg Bid)
    £87 Avg Bid
    22 bids

    vlookup program macro as discussed in chat

    £199 (Avg Bid)
    £199 Avg Bid
    1 bids

    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

    £97 (Avg Bid)
    £97 Avg Bid
    26 bids

    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

    £8 (Avg Bid)
    £8 Avg Bid
    1 bids

    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

    £24 (Avg Bid)
    £24 Avg Bid
    1 bids

    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 [login to view URL] details on PM

    £3 / hr (Avg Bid)
    £3 / hr Avg Bid
    5 bids

    ...Python or another language. We do not want a webscraper to do this manually. Must use a script. Manual will take too long. The FINAL product should just be a long excel list with 5 columns as follows. last name |first name | company | position | email Step 1: Narrow search for candidates on linkedin using sales navigator or recruiter, based on

    £9 / hr (Avg Bid)
    £9 / hr Avg Bid
    20 bids

    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

    £64 (Avg Bid)
    £64 Avg Bid
    8 bids

    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

    £17 (Avg Bid)
    £17 Avg Bid
    5 bids

    I need your help to write a simple script to perform below actions. 1. download csv files in loop. I have 1 url which will have one variable parameter which is an incremental number to be looped for reference: this is what I have written in VB MyUrl = 'https://somewebsite.com/parameter1=something&parameter2=' for i = 1 to 30 MyNewUrl = MyUrl &

    £19 (Avg Bid)
    £19 Avg Bid
    14 bids

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

    £84 (Avg Bid)
    £84 Avg Bid
    55 bids

    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

    £185 (Avg Bid)
    £185 Avg Bid
    10 bids

    ...creators to join us for our endeavour. We are looking for someone to make a complete tutorial video series for Microsoft Excel 2016. Reference video - [login to view URL] - Format: Screen-Recording with Voice-over & Text - Language: English - Please ensure audio is both clear and audible. Please minimize background noise &

    £288 (Avg Bid)
    £288 Avg Bid
    17 bids

    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.

    £41 (Avg Bid)
    £41 Avg Bid
    16 bids

    i have some work in excel. This is about smaller Excel works, i.a. First 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

    £18 (Avg Bid)
    £18 Avg Bid
    14 bids

    I need help to keep the colour of my vlookup without using conditional formating. I want column K in the details to pupulate with the selected colour in the dashboard.

    £17 (Avg Bid)
    £17 Avg Bid
    11 bids