Filtrer

Mes recherches récentes
Filtrer par :
Budget
à
à
à
Type
Compétences
Langues
    État du travail
    1,172 Vlookup travaux trouvés au tarif de EUR
    Do some Excel Work S'est terminé left

    PLATE FORM - EXCEL Vlookup, Hlookup, Pivot Table, Validation, Formatting, Macro, Len, Trim, Proper, True False, Sum, Count, Count A, Count Blank, Chart, Count if, Clean, Concatenate, Filter, Advance Filter, Custom Filter, Right, left, Upper, Lower, Proper, Convert, Tex To Column, Formatting and more excel functions. TYPING SPEED In English

    €27 - €224
    €27 - €224
    0 offres

    I require some data to be returned based upon a table in another excel worksheet. Very simple job. Instructions in the sheet titled "Instruction"

    €11 (Avg Bid)
    €11 Offre moyenne
    7 offres
    excel vlookup 3 jours left

    I have two sheets. I need to find if a number in sheet 'FEB' Col. B or Col. C has the same number in Sheet 'DTE' Col. B or C. If it does I need the number from Col.A on both sheets moving to a new sheet (example is given on third sheet) Please be aware that on Sheet 'DTE' that individual numbers are seperated with a ','

    €28 (Avg Bid)
    €28 Offre moyenne
    25 offres

    Need help being walked through 2 spreadsheets of data creating Sales Orders, Sales Order Details and possibly Sales Order Management.

    €90 (Avg Bid)
    €90 Offre moyenne
    32 offres

    Need help being walked through 2 spreadsheets of data creating Sales Orders, Sales Order Details and possibly Sales Order Management.

    €396 (Avg Bid)
    €396 Offre moyenne
    37 offres

    ASP.NET BASED WEB APPLICATION , WHERE USER INPUT MULTIPLE EXCEL FILE MAXIMUM 30 WITH MILLION...WITH MILLIONS OF RECORDS WITHOUT ANY FORMAT ,AND ALL THESE SHEET MERGED INTO INE AT THE END AFTER DOING MANY MAPPING BASED ON EXCEL COLOUMN WITH ANOTHER MASTER COLUMN AND VLOOKUP,HLOOKUL THROUGH SOME CLICKS AND OUTPUT SHOULD BE ONE FILE WITH SPECIFIC FORMAT.

    €1 / hr (Avg Bid)
    €1 / hr Offre moyenne
    1 offres
    Excel Document S'est terminé left

    Hi I have regular work with excel documents for you. If you are good at all things having to do with excel please let me know. - creating pdf from excel files -...have regular work with excel documents for you. If you are good at all things having to do with excel please let me know. - creating pdf from excel files - excel formulas - vlookup array

    €109 / hr (Avg Bid)
    €109 / hr Offre moyenne
    44 offres
    Excel schedule builder help. S'est terminé left

    I have a tab where I build a schedule out. It is suppose to pull information through vlookup and match from a raw data tab. But only some names pull their data. I cannot figure out what is wrong. I can also pay for any general upgrades you may see that you could do. like maybe a search function in the drop down box? I am poor at excel.

    €4 / hr (Avg Bid)
    €4 / hr Offre moyenne
    23 offres
    I need Excel help S'est terminé left

    I have to do vlookup to get the answers to area_code under G, area_name under H, and period_name under I using Series, Dates, and Area on the left bottom. I have done it a million times and I keep coming up with the wrong answer. I am uploading the workbook I hope

    €18 (Avg Bid)
    €18 Offre moyenne
    15 offres

    I have an excel workbook that brings in dat...are production records from jobs produced. I'm trying to create a Vlookup in the "Waste Pivot" sheet that takes a value (prod order) in that pivot, looks up that order in the sheet 2 pivot, and returns the value in the "sum of qty" field. From what I can tell, you can't use Vlookup with pivot tables...

    €77 (Avg Bid)
    €77 Offre moyenne
    6 offres

    On my sheet my dropdown name box in May and June doesn't always pull data from the Rawdata tab. Vlookup and match are broken somehow. Also I have a column I keep hidden in AK that should pull data from Rawdata tab. It pulls a G from raw data and if there is a G the conditional formating is suppose to turn role in B column green. Its not working.

    €4 / hr (Avg Bid)
    €4 / hr Offre moyenne
    8 offres
    I need a Excel Expert S'est terminé left

    Having trouble with case study formulas especially with 'VLOOKUP', the rest of the case studies are done, if you can also do a write up on how to follow the process.

    €36 (Avg Bid)
    €36 Offre moyenne
    7 offres

    If functions and Vlookup in Excel

    €18 (Avg Bid)
    €18 Offre moyenne
    35 offres
    Microsoft Office Excel S'est terminé left

    ...Tables, Charts, Graphics, Dash Board creation of reports and Calculation. Experience in Advanced level MS Excel skills such as Macros, VBA Coding, Power Query, Pivot Tables, VLOOKUP and HLOOKUP. Ability to covert data into decisions and predictability Should be well versed in Excel with arrays, data functions, sparklines, outlines, scenario, VBA and Macros

    €18 / hr (Avg Bid)
    €18 / hr Offre moyenne
    27 offres
    Inventory report - 2 S'est terminé left

    Fix VLOOKUP error in file we will supply

    €15 (Avg Bid)
    €15 Offre moyenne
    17 offres
    Inventory report S'est terminé left

    Working on an inventory file and trying to add VLOOKUP functions but running into errors.

    €318 (Avg Bid)
    €318 Offre moyenne
    30 offres

    I am good in excel & word . I have 3 years experience in excel . I know lots of things in excel like vlookup , hlookup & pivot table etc .. if you like my work so please let me know for further work s. Regards, Hemant Ph- 8130078341

    €7 (Avg Bid)
    €7 Offre moyenne
    1 offres

    ...social network built on PHP. We need help in adding a module for MS excel kind of functions like 1. Table mgmt and cell for data entry 2. Sum / Multiple / Add / Divide / vlookup and Hlookup/ Build graphs - 10 types (bar char/pie/linear) 3. Include @mentions kind of functions to add on tables and share to group or users of forum 4. Share to members

    €202 (Avg Bid)
    €202 Offre moyenne
    16 offres

    ...Sheets of data. Sheet 1 has 16,000 rows that includes a domain name Sheet 2 has about 9,000 row that includes a domain name I want you to write a Google sheets function/vlookup etc that takes each row in sheet 1, take the domain name, looks for a match in sheet 2. Where a match is found, the data in the row in sheet 2 is copied across and added to

    €36 (Avg Bid)
    €36 Offre moyenne
    5 offres

    ...excel spreadsheets based on data - then be able to export data based on the format for import into QuickBooks and our Magneto website. This will require a excel dashboard, vlookup and macros. Right now we combine 3 to four spreadsheets to get a master, then we rip it apart to make separate imports. We do have a common field which is SKU - but we have

    €63 (Avg Bid)
    €63 Offre moyenne
    9 offres
    MAKE GIS GEODATABASE S'est terminé left

    I have data in fields and records (Excel). I would like to enter it in ARCMAP layout using single key from each record. something like VLookup function in excel. Attached is the layout; when I enter the Culvert No, I need all fields to be filled.

    €182 (Avg Bid)
    €182 Offre moyenne
    13 offres

    ...be possible if he already received the data in the right format/structure) or connects the data to the “base-data” sheet of the tool using basic excel functionality, like “vlookup()” or “sumif()”. 2. He switches to the “configuration” sheet and configures the tool to deliver the desired output (for example format of the charts, language, e...

    €529 (Avg Bid)
    €529 Offre moyenne
    45 offres

    ...marketplace that we sell on, and in this this tab we have all our information that we are selling, like prices, stock levels, when last the stock level was checked. Now we use a vlookup command to compare the prices, stock levels and more for each product from each supplier that we have on separate tabs, each supplier has a live xml link that lets up manually

    €66 (Avg Bid)
    €66 Offre moyenne
    6 offres

    I'm looking for somebody who can do VLOOKUP in Excel. I need to compare two files and get data from it. It's just 600 lines. I attached two excel files. First if [se connecter pour voir l'URL] and I need to compare it with [se connecter pour voir l'URL]

    €16 (Avg Bid)
    €16 Offre moyenne
    16 offres
    Fix Google Sheets Vlookup S'est terminé left

    vlookup google sheets did not find value

    €16 (Avg Bid)
    €16 Offre moyenne
    5 offres

    ...state/region and the city. Formula on the excel for this is: State: =VLOOKUP(F3, 'Tabela Airlink'!C6:K59, 8) City: =VLOOKUP(F3, 'Tabela Airlink'!C6:K59, 9) NOTE: For change #1 has a formula that requires to look at a chart that is included in the excel. Excel formula of that is =IF(F3=0,0, VLOOKUP(F3, 'Tabela Airlink'!C6:I59, 7))...

    €39 (Avg Bid)
    €39 Offre moyenne
    9 offres

    Hello. I have a excel spreadsheet that links up to my suppliers products on a live feed. and we are using the vlookup formula to pull stock levels, and prices and more. we need this to automatically update every few minutes and we need to be emailed if certain numbers change. let me know if you need more info. Extra what we want done: We preferably

    €77 (Avg Bid)
    €77 Offre moyenne
    8 offres

    have two columns that i want to exclude one from the other

    €16 (Avg Bid)
    €16 Offre moyenne
    66 offres

    [se connecter pour voir l'URL] Please view that sheet, the Sales and Payments tabs are entered manually.. The Summary tab is calculated automatically, when you select a name from cell A2, the rest of the information should be calculated automatically..

    €1 - €5 / hr
    Scellé
    €1 - €5 / hr
    7 offres
    Excel data processing S'est terminé left

    Creating one master excel spreadsheet from various different excel and pdf documents. Adding prices with vlookup. Around 10 working hours every month.

    €4 / hr (Avg Bid)
    €4 / hr Offre moyenne
    47 offres
    help with excel case study S'est terminé left

    this is a simple case study for school work and I am having issues using vlookup and pivot tables to solve and organizing the KPIS.

    €19 (Avg Bid)
    €19 Offre moyenne
    18 offres
    Project for Chandrasekhar G. S'est terminé left

    I have 1 year experience of excel work. I know that vlookup and h lookup. etc

    €1 / hr (Avg Bid)
    €1 / hr Offre moyenne
    1 offres
    Excel expert S'est terminé left

    I need help fixing a Vlookup that references a folder i don't have access to, but there is a worksheet with the options. See file - column H and K need fixing based on Matrix in worksheet titles '[se connecter pour voir l'URL] Description'

    €16 (Avg Bid)
    €16 Offre moyenne
    7 offres

    i am a purchaser for a company, i want to make my work more comfortable and fresh now i want to find some one that know about excel's useful build-in function such as VLOOKUP, LOOKUP, INDEX/MATCH and more to build me a purchase order form with drop down menu on item products code cell with the item picture also, for more detail you can contact me

    €25 (Avg Bid)
    €25 Offre moyenne
    6 offres
    Excel reporting tool S'est terminé left

    We need an excel expert with deep knowledge in macros, pivos, vlookup

    €15 / hr (Avg Bid)
    €15 / hr Offre moyenne
    47 offres

    I do have an excel ques...copy the number in Cell K into another worksheet or workbook. I tried doing a IFANDTHEN formula but could not get it to work, I also tried a combination of formulas and a vlookup but that also did not work. Can you help me with this? I have attached a small spreadsheet as an example but the one I am working on is much larger.

    €15 (Avg Bid)
    €15 Offre moyenne
    3 offres
    Excel Expert needed S'est terminé left

    We are Looking for someone expert in [se connecter pour voir l'URL] qualify for this project I will send some of the se...project I will send some of the selected freelancers an excel test to complete in a given time. You can expect in test expect these functions ROUND, SUM, MIN, MAX, AVERAGE, VLOOKUP, Custom Sort (multiple levels). CONCATENATE, IF, Conditional formatting,

    €23 (Avg Bid)
    €23 Offre moyenne
    26 offres

    I have a sheet in excel that I use to quote work need some vlookup and VBA to insert data. this worksheet is very simple I have a vlookup for accounting number want product instead. I want a VBA box to insert all data instead of in cells.

    €284 (Avg Bid)
    €284 Offre moyenne
    46 offres

    ...specific value I have a data in Excel sheet, out of which I need to allocate work to my team on day to day basis with specific change in formats, Presently I do it with Vlookup, but I am looking for more feasible and time saving solution. I would like to have email button incorporated so as I can for ward the work allocation to the individual directly

    €129 (Avg Bid)
    €129 Offre moyenne
    1 offres
    Tableau and Excel Modelling S'est terminé left

    I need proper model in Excel and Tableau. Which is easy to under sta...item no. you might need to transpose data in refer p data as required for your modelling. There are 2 different spreadsheet and you will need to combine them both using Vlookup, match, ifelse, than,rank and many more. I need modelling in Tableau and Excel. Refer to attch file

    €21 (Avg Bid)
    €21 Offre moyenne
    5 offres

    I have a spreadsheet with part numbers and costs stored in it. I need to be able to paste daily sales data into a new sheet (sales) on the spreadsheet and then run a macro that will go through each row and enter the cost price for the part sold from the other sheet (costs). I need the cells to contain actual data and not a formula, that is why I want to use a macro. If the part on the sales she...

    €106 (Avg Bid)
    €106 Offre moyenne
    32 offres

    We're looking for an expert in Google Sheet/Excel formulas with knowledge of functions and vlookup that can build a formula allowing to speed up the work on 2 separate sheets.

    €14 / hr (Avg Bid)
    €14 / hr Offre moyenne
    42 offres
    Help me with VLookup Formula S'est terminé left

    Simple Excel Question. I just need to do a VLookup or whatever method formula created to take on set of data, listing my quantity and part number. And check it against another set of data - where part number is listed with my cost. Return my cost to the numbers that I stock. So in the example attached with a sample of numbers: In column D I want

    €18 (Avg Bid)
    €18 Offre moyenne
    11 offres

    ...make sure we are only bring in the rows of data we need and NOT duplicate data that we do not. Looking for someone who is an Excel EXPERT and VERY experienced with using vlookup fuction of Excel. Except about an hour or so discussion ensuring the data is being handled properly. The job is quite simple but very important that it is accurate so we will

    €107 (Avg Bid)
    €107 Offre moyenne
    40 offres

    ...make sure we are only bring in the rows of data we need and NOT duplicate data that we do not. Looking for someone who is an Excel EXPERT and VERY experienced with using vlookup fuction of Excel. Except about an hour or so discussion ensuring the data is being handled properly. The job is quite simple but very important that it is accurate so we will

    €93 (Avg Bid)
    €93 Offre moyenne
    45 offres

    We need a small project completing.... i believe it involves "VLOOKUP" and will simply copy data from one spreadsheet in to another. Spreadsheet 1 will reference a customer code. We need to look up the customer code on Spreadsheet 2 and copy certain columns (address/client name etc) from Spreadsheet 2 and put in to Spreadsheet 1.

    €18 (Avg Bid)
    €18 Offre moyenne
    31 offres
    online calculator S'est terminé left

    I need to turn an excel spreadsheet with vlookup features and some additional calculations into a php online calculator. will require 10 user UI inputs then will run and generate a one page pdf output.

    €943 (Avg Bid)
    €943 Offre moyenne
    49 offres

    ...50 have blue font color. C) Fill in the column ”ExtraBonus” accordingly to the table in the sheet ”Bonus” taking into account values in the column ”Bonus” (use the function vlookup). D) Add the new sheet named ”Out1” and copy there the output of the data filter due to the following rules: • all men with no children or all women with th...

    €4 / hr (Avg Bid)
    €4 / hr Offre moyenne
    21 offres
    Excel data tool S'est terminé left

    Hi, I need an excel tool My project looks very simple for someone who know excell. I have many files of lists ...to do an Automatic research from thoses 6-7 systems, and excell give the result when the ID refer to a client in the 6-7 Systems. So it will be especially Pivot Table, and Vlookup. ( The best would be a VBA) thanks you very much. regards,

    €82 (Avg Bid)
    €82 Offre moyenne
    97 offres
    Excel VLOOKUP work S'est terminé left

    I want to do a VLOOKUP to move data from one spreadsheet to another. I can do VLOOKUPs but this has an element that I do not know the VLOOKUP script for. The spreadsheet 'ABR template' contains some data with Suburbs in Australia and telephone prefixes. The spreadsheet 'Postcodes by Suburb' contains some data with Suburbs in Australia and Postcodes

    €214 (Avg Bid)
    €214 Offre moyenne
    28 offres

    Meilleurs articles de la communauté Vlookup