Tapis

Carian terbaru saya
Tapis melalui:
Bajet
hingga
hingga
hingga
Jenis
Kemahiran
Bahasa
    Status Pekerjaan
    1,325 vlookup tugasan ditemui, harga dalam USD
    multiple results vlookup 5 hari left
    DISAHKAN

    I have a spreadsheet that is sales data. I want to pull data based on the order number but sometimes there are multiple transactions with the same order number. When I use vlookup it just pulls the first number

    $21 (Avg Bid)
    $21 Avg Bida
    19 bida

    I am an front office assistant, working for a refrigeration company. I am trying to build an Excel Template that will compare data from 2020 with data from 2019. I need it to have the following columns: 1) Is Part on old list 2019 and if so, what line? (2) Is Part on old list 2019 (3) If it's there, do the programs match? (4) If programs match, do the qty's match? (5) If program & q...

    $18 (Avg Bid)
    $18 Avg Bida
    4 bida

    Hi Md Imteyaz K., I noticed your profile and would like to discuss a potential project I plan on proposing to my management team. It would be an excel training course (which would require you to screen-record and do a voice over or notes) looking at spreadsheet creation and navigation, formulas (basic and advanced) such as SUMIF, VLOOKUP, MATCH etc, as well as VBAs and MACROS. Does this seem like ...

    $130 (Avg Bid)
    $130 Avg Bida
    1 bida

    contain comparing and vlookup function

    $95 (Avg Bid)
    $95 Avg Bida
    27 bida

    We have a fairly large amount of data that we've gathered for the purposes of property valuations and a variety of property research that we've done. The data is mainly in tables in various excel Excel files and we filter it, query it and analyse it in excel using autofilters, pivot tables, vlookup and index,match formulas on so forth. The volume of data and quantity of excel files and...

    $450 (Avg Bid)
    $450 Avg Bida
    40 bida

    I have an excel where I need to make a VLOOKUP work to pull data into a new column I need the team name from the 2019 worksheet to be added to the 2020worksheet based on the players ID number.

    $10 (Avg Bid)
    $10 Avg Bida
    9 bida

    I am creating a dashboard in excel fo rone of the reports but I have multiple conditions where in need support on Vlookup and Macros to create those filters/Pivots .

    $84 (Avg Bid)
    $84 Avg Bida
    27 bida

    I have a cycle count project that I'm working on and we are struggling to create a formula that can find specific part number and populate the associated serial numbers. This is a struggle because we have multiple lines of the same part number and each part number has it's own serial number. The vlookup we are using only pulls the first 1st of the part number and matches it against the 1...

    $1150 (Avg Bid)
    $1150 Avg Bida
    13 bida

    Melakukan sejumlah pekerjaan Excel seperti mengentry data, memasukkan rumus didalamnya seperti vlookup,hlookup,if,sum, dll

    $90 (Avg Bid)
    $90 Avg Bida
    47 bida

    I have a file where the part numbers are jumbled. You need to match the righjt colum to the left one. SImple and can be easily completed with v lookup function. 10 minutes job.

    $13 (Avg Bid)
    $13 Avg Bida
    35 bida

    How much to create: Trying to design a commission spreadsheet that we can track Multiple persons YTD and Monthly and Dollar sales in tiers that escalate the salespersons %rate of Commission and at each tier threshold calculate accurately the commission due them. a single sale might take them across 2-3 tiers and each tier gets calculated and added together for the total commission . With a year...

    $23 (Avg Bid)
    $23 Avg Bida
    10 bida

    I am working on a project for a client and cannot figure out how to pull the data I need from different excel spreadsheets into one sheet. I believe I need either an "if then formula or a vlookup.

    $20 (Avg Bid)
    $20 Avg Bida
    13 bida

    Requesting help to create a financial model to underwrite real estate developments/operations. Model will need to be very dynamic and flexible for inputs. You will not need to know the financial aspects of real estate, but strong understanding of financial concepts and how excel calculates results. Looking for someone who is advanced to expert level writing formulas and knows how which is most ...

    $11 / hr (Avg Bid)
    $11 / hr Avg Bida
    31 bida

    The Excel file Is composed of three worksheet 1. Initial Raw data 2. Data from Last Month 3. Data from the current month but those could have different names then given here. Because of that GUI dialog should be created asking to point which one of the worksheets in the excel file is 1, 2 or 3. After that, the VBA script should copy worksheet 1 to the new worksheet, wit...

    $41 (Avg Bid)
    $41 Avg Bida
    27 bida

    I have a current excel document which requires many user inputs from drop down lists and custom entries. Many instances of vLookup etc. Current design is complete but would like the final product to be more user friendly.

    $339 (Avg Bid)
    $339 Avg Bida
    44 bida

    I need to be able to reference my secondary tab based on table, day of month and day of week. I thought it was countifs or vlookup but I am very stuck

    $20 (Avg Bid)
    $20 Avg Bida
    27 bida

    Hi, I currently export 2 files from my inventory platform. From there i run an day specific macro file on one of the files exported and then i move/copy the second one to the macro ran file. from there, i perform a vlookup to pull data points together. I'd like to set up a template that would help me take the files i export daily...move/copy them into a template and hit "run" or ...

    $159 (Avg Bid)
    $159 Avg Bida
    21 bida

    Must be a very good excel user, I have two work books I need some vlookup etc done and its really urgent

    $64 (Avg Bid)
    $64 Avg Bida
    36 bida

    Project Overview: 1. This spreadsheet already contains some vLookup formulas. Please do not alter these formulas unless it is necessary to achieve the tasks outlined herein, or if the approach used can be improved. 2. The following fields require manual inputs and should be ignored: Requestor, Event Date, Event ID, Campaign Name, Comments. 3. In essence, this spreadsheet will manage budge...

    $21 (Avg Bid)
    $21 Avg Bida
    33 bida

    i have 2 sheet project sheet : projects which include A column = project names and B column = task status task sheet: A column = task name, B column = project name, C column = task status( True, False) i used this formula ( if the project Sheet A column = tasks Sheet B column then copy the tasks sheet Column C and paste it in project sheet B column. =VLOOKUP(A2,Sheet2!$B$2:$C$100,2,0) i need wh...

    $32 (Avg Bid)
    $32 Avg Bida
    26 bida

    We are looking for someone who is good with Excel/Spreadsheet functions to format Data using VLOOKUP and other functions.

    $20 (Avg Bid)
    $20 Avg Bida
    28 bida

    Need to get data in a different format, example shown on sheet2 how data is required

    $21 (Avg Bid)
    $21 Avg Bida
    30 bida

    Create a quote tracker and help with vlookup

    $14 / hr (Avg Bid)
    $14 / hr Avg Bida
    23 bida

    I'm a Realtor in Vancouver, Canada and a brokerage owner. I have lots of tasks that I would like to outsource. I'm looking for a full-time VA that would help me with these tasks. Here is what I'm looking for in the perfect candidate. - Excellent English, both writing and speaking should be fluent. You will be talking with clients and writing Social media posts. They should be same ...

    $8 / hr (Avg Bid)
    $8 / hr Avg Bida
    45 bida

    Create a quote tracker and help with vlookup

    $13 / hr (Avg Bid)
    $13 / hr Avg Bida
    27 bida

    Create a quote tracker and help with vlookup

    $21 (Avg Bid)
    $21 Avg Bida
    38 bida

    Need to quickly learn vlookup referenced calculated item/field. Need someone to sit with me for 30 minutes to an hour today to teach me this.

    $11 / hr (Avg Bid)
    $11 / hr Avg Bida
    5 bida

    Hi Freelancer, I need help on a formula for a VLOOKUP that will pull multiple specific values from a separate tab (in the same work book) based on the value entered into a single cell. Was able to create the formula below, however it only pulls the 1st row of all of the data I need (rather than the full range). Initially, I created a dropdown list with a macro to pull this data, but is it too...

    $51 / hr (Avg Bid)
    $51 / hr Avg Bida
    36 bida
    Google Sheets Tamat left

    I would like someone to help me with Google Sheets. Specifically log in using team viewer and be available to help me for an hour. So please bid your hourly rate. The first hour I need help with Vlookup from a different tab and answer assorted questions. I would like to be able to schedule additional hours for help and questions as needed. Ideally I am looking for an ongoing resource with helping ...

    $5 / hr (Avg Bid)
    $5 / hr Avg Bida
    4 bida

    I have exported source data that will be refreshed every week. When imported into Excel it needs to be re-ordered so all grouped data is on same row, multiple columns instead of multiple cells down as it is now. I've done this manually inside Excel and very time consuming for hundreds of rows. Plus I need a repeatable process so I can refresh with new source data every day/week. So a macro o...

    $107 (Avg Bid)
    $107 Avg Bida
    17 bida

    I have a database. I know how to make a drop down menu. I want the drop down menu once a selection is made advance to the adjacent cell. When I type in the shape I want the shape selected from the database on another sheet and return the weight shown on the other sheet and the area of the shape. I can do all the other functions I need once this is achieved. I know go to would advance to the ce...

    $31 (Avg Bid)
    $31 Avg Bida
    32 bida

    I need you to fill in a spreadsheet with data.

    $1 - $6 / hr
    $1 - $6 / hr
    0 bida

    I have an assignment where I need someone who knos VLOOKUP, CONTIF and SUM formulas.

    $12 / hr (Avg Bid)
    $12 / hr Avg Bida
    60 bida

    I want to turn an excel with multiple pages and formulas into a web application that users can access online. It is an educational application used during management courses. The application will allow users to understand simple management concepts such as revenue, expenses, profit, investment, cash flow, etc. based on manually entered data. The application must allow: creation of user and admin...

    $2349 (Avg Bid)
    $2349 Avg Bida
    56 bida

    Hii, This is deepak kumar i am still fresher in excel but i know that the basic things about excels. like as.. VLookup, data entry of salary sheet, etc

    $8 (Avg Bid)
    $8 Avg Bida
    1 bida

    Hii, This is deepak kumar i am still fresher in excel but i know that the basic things about excels. like as.. VLookup, data entry of salary sheet, etc

    $8 (Avg Bid)
    $8 Avg Bida
    1 bida

    Ability to reflect on one's own work as well as the wider consequences of financial decisions. Compiling and presenting reports, budgets, business plans, commentaries and financial statements. Analysing accounts and business plans along with other disciplines like Income Tax, GST and other relevant enactments. I have Excellent knowledge of Excel (Pivot tables, formulas, VLOOKUP etc.) Exten...

    $2 / hr (Avg Bid)
    $2 / hr Avg Bida
    1 bida

    I am working with renowned CA firm as a article for last 3 years. ACCOUNTING:- Ability to reflect on one's own work as well as the wider consequences of financial decisions. Compiling and presenting reports, budgets, business plans, commentaries and financial statements. Analysing accounts and business plans along with other disciplines like Income Tax, GST and other relevant enactments. M...

    $24 / hr (Avg Bid)
    $24 / hr Avg Bida
    1 bida

    I am working with renowned CA firm as a article for last 3 years. ACCOUNTING:- Ability to reflect on one's own work as well as the wider consequences of financial decisions. Compiling and presenting reports, budgets, business plans, commentaries and financial statements. Analysing accounts and business plans along with other disciplines like Income Tax, GST and other relevant enactments. M...

    $14 / hr (Avg Bid)
    $14 / hr Avg Bida
    1 bida

    I have Excellent knowledge of Excel (Pivot tables, formulas, VLOOKUP etc.) Extensive knowledge of multiple generations of Microsoft Excel software. Good creative and critical thinking skills. Strong problem-solving and troubleshooting abilities. Ability to reflect on one's own work as well as the wider consequences of financial decisions. Compiling and presenting reports, budgets, business...

    $4 / hr (Avg Bid)
    $4 / hr Avg Bida
    1 bida

    Ability to reflect on one's own work as well as the wider consequences of financial decisions. Compiling and presenting reports, budgets, business plans, commentaries and financial statements. Analysing accounts and business plans. I have Excellent knowledge of Excel (Pivot tables, formulas, VLOOKUP etc.) Extensive knowledge of multiple generations of Microsoft Excel software. Good creati...

    $3 / hr (Avg Bid)
    $3 / hr Avg Bida
    1 bida

    I have an excel sheet with different sheets. Each sheet for specific product range. The last sheet is for the pricelist and quote sheet. When adding a specific product code in the pricelist tool sheet, need it to search with all the others sheets and if found, to present the value in the others columns. I successfully did that for the first sheet "alerton" only but cannot make it to lo...

    $11 (Avg Bid)
    $11 Avg Bida
    28 bida

    I am looking for a Excel Export VA, I need some help for Formula, Vlookup and Other task related to excel. Please bid if you are good in excel sheet. Thanks Write Y if you read this in your proposal.

    $4 / hr (Avg Bid)
    $4 / hr Avg Bida
    34 bida

    Melakukan sejumlah pekerjaan Excel Saya menguasai pengolahan data, menguasai penggunaan rumus if, vlookup, hlookup, pivot, sumif

    $121 (Avg Bid)
    $121 Avg Bida
    43 bida

    Excel Expert with success in maintaining and organizing data, including dictionaries, metadata repositories, and cross-reference indexes across a broad range of industries. Skilled in VLOOKUP formula development, Pivot Table generation, and Pivot reporting. Demonstrated ability to use critical and strategic thinking to resolve discrepancies, fill gaps, and sustain quality control benchmarks.

    $3 / hr (Avg Bid)
    $3 / hr Avg Bida
    36 bida

    Need to have two Data Columns brought over using v look ups

    $18 (Avg Bid)
    $18 Avg Bida
    2 bida
    Need expert Tamat left

    What is the group project about? This assignment may be completed in a group of 3 students or less (you may also work on your own). You will prepare an Excel Workbook based an existing organization or topic of your choice presenting company information and statistics such as: • inventory • human resources • sales and revenue • budgets • financial analysis and forecasti...

    $13 (Avg Bid)
    $13 Avg Bida
    2 bida

    Hello, Need an excel vlookup pro. Probally take you 10mins to do (for a pro). 1- need to compare two columns of data and allocate other data in 2 other columns

    $5 / hr (Avg Bid)
    $5 / hr Avg Bida
    49 bida

    Macros for Excel Spreadsheet On Champion Data Sheet Delete Column B Delete Columns G to Q Insert formula =ROUND(F2,1) into Column G Insert formula =ROUND(G2,1) into Column H Copy Down Copy both Columns and Paste Value into Columns E and F Delete Columns G and H Remove Spaces in Column B using Replace Insert Column before Column E Insert Formula =B2&C2&D2 and Copy Down Copy Column...

    $5 / hr (Avg Bid)
    $5 / hr Avg Bida
    35 bida

    Looking for someone who knows how to use formulas and functions, to create them in a spreadsheet vlookup Index Match Nested Functions (e.g combine IF and INDEX functions in same cell) working with multiple tables it is important that you have a very good understanding of multiple functions within cells, not just one or two. the aim is to summarize key data using complex formulas looking to...

    $16 / hr (Avg Bid)
    $16 / hr Avg Bida
    31 bida

    Artikel Komuniti vlookup Teratas