Vlookup dataJobs
I have an immediate issue that needs resolving so anyone that can jump on with me. Issue: My supplier sends me a spreadsheet for pending names that need to be paid for. I have a spreadsheet for names that i have already paid for. I just want an easy way to match the names he is asking payment for to match with my ...immediate issue that needs resolving so anyone that can jump on with me. Issue: My supplier sends me a spreadsheet for pending names that need to be paid for. I have a spreadsheet for names that i have already paid for. I just want an easy way to match the names he is asking payment for to match with my sheet. I need confidence that the matching is done correctly. I have tried using MATCH and VLOOKUP but am not feeling confident with the results. Anyone available to...
I am looking for a freelancer to assist me build an Excel model for data management. I have a clear structure for the model I just need help to implement. I require intermediate functions such as VLOOKUP and conditional formatting to be used. I don't require someone to do, I need someone to assist and guide.
I need you to quickly answer the question in this forum, tell me the answer of the right formula or just simply answer directly in the GS : https://docs.google.com/spreadsheets/d/1Ujmulf8YLeRbOtJm0Q4RhDifc_Z7WS3FREN7NVvzttg/edit#gid=935726050. I will pay you $2-$5 per formula depens on the complexcity, this job is good for a reviewer seeker.
...Inventory Order Tracking Management Excel Workbook Template which i can develope. Currently, I have a manual system in place that I am looking to Redesign. Specifically, I need better organization and accessibility for my inventory and order tracking. The ideal candidate will have experience creating Excel sheets using pi ot tables and advanced excel formulas (Mix of: Vlookup, Index, Mach, etc..) that automate processes and improve my data analysis. The workbook should include order details (location, quantities, status). Some additional features that would be helpful include the ability to track track the order live if possible. Here is a brief of the how the process curently is; Starts- Orders are listed in priority orders from most important first and we work accord...
SEARCHING FOR AN EXPERT IN ALL THINGS AMAZON $1800/Month USD REMOTE - work from home About the job: Move2Play is a rapidly growing kids toy company in the e-commerce space. We were founded 6 ye...Years experience as an Amazon brand manager including catalog management, creating support cases, product detail pages, reimbursements 2 Years+ Selling on Walmart with in-depth knowledge of Seller Center +Walmart Advertising Proficient at complex functions within google sheets including VLOOKUP, Pivot Tables, Indexing, ect. Fluent in English with excellent written and verbal communication skills Bonus Skills: Experience using Adwords especially as it relates to driving traffic to Amazon Background in data analytics and statistics $1800/Month USD 14 Days Paid Time Off Sick Leav...
I am looking for an experienced VLookup expert to assist with a project. Specifically, the primary purpose of the VLookup is to identify and locate specific pieces of data within a table structure. I understand the complexity of this task and want to make sure the job is done correctly so I will be providing the specific dataset myself. The desired output is an Excel spreadsheet so mastery of VLookup formulas is a must. If you have the skills to efficiently complete such a task then I would love to discuss working together. Thanks!
I am looking for a freelancer who can help me sort data alphabetically using the Vlookup function in Excel. The ideal candidate should have experience in Excel and be proficient in using Vlookup. The output format should be an Excel file. There are no additional functions or formulas required for this project. The task is simple and should not take long to complete.
Online help for powerpivot. Creating in assisting mode a mapping link (like Vlookup) with chart of accounts data in the General ledger journal.
I have two excel sheets with approximately 100 employee file lines. both excel sheets are in different data order and not organized in the same method. steps needed: - update salary column for each staff member (pull data manually or use perhaps use VLOOKUP) - review the master staff list and add any missing names + salary number to the final sheet -Add the email addresses to all staff members to the final sheet -highlight any issue data or concerns in data for my review.
I need someone who is skilled in Excel Spreadsheets to review my work and change my basic formulas so that they all work. The ideal candidate should be able to complete this task within 12 hours. Skills and Experience: - Proficient in Excel Spreadsheets - Knowledge of basic formulas - Ability to review and modify existing formulas - Detail-oriented and able ...change my basic formulas so that they all work. The ideal candidate should be able to complete this task within 12 hours. Skills and Experience: - Proficient in Excel Spreadsheets - Knowledge of basic formulas - Ability to review and modify existing formulas - Detail-oriented and able to identify errors in formulas - Time management skills to complete the task within 12Hours -Able to use VLOOKUP Formulas -Able to prob...
My organization is looking for someone to help us with creating and implementing a Vlookup in Excel with data from Sheet 1 to Sheet 2. This Vlookup sheet would do a comparison of data from both the sheets, match the relevant pieces and generate the desired result for our business. We do not require any additional Excel features or functions other than the Vlookup itself, and do not necessitate any conditional formatting or pivot tables this time. However, should anything else be required for the project, we may get back to the freelancer for assistance. The ideal candidate should have excellent knowledge and understanding of Excel, as well as have the capability to create and implement Vlookup formulas within the workbook. We hope to find someone ...
I need an Excel file for data analysis, specifically for analyzing sales data. The ideal freelancer should have experience with pivot tables and be able to implement them in the file. No specific formulas or functions are required, but knowledge of VLOOKUP/HLOOKUP and custom formulas would be a plus.
I need someone to help me link my Google sheets, form, and docs, and generate a PDF. The ideal candidate should have experience in Google Suite and be able to work with the following requirements: - Google Form should include multiple-choice fields - Google Sheets should have simple calculations automation and Vlookup - Google doc Template - The generated PDF should be in PDF format. Please send me your proposal with your relevant experience. Thank you.
I have prices attached to a spreadsheet that ties it to name(CU) associated with the price. My separate sheet will have have the names (CU’s) that I utilized with a quantity out from it. I need that sheet to do a v loop up pair it with the CU that’s on a separate sheet and calculate the price x the quantity. Could I have a template built where I could plug and play?
I need someone to help me with a Vlookup function in Excel. The purpose of the function is to find matching data. I have a sample file that needs to be worked with, and the Vlookup function needed is basic. Ideal candidates should have experience in Excel and be proficient in Vlookup functions.
I have 2 google sheets with live population of data from 2 different google forms. I have 2 people counting stock and I would like to check if the data is correct. Create a formula for me to compare 2 sheets of data to each other. First find the match in the fourth column of each sheet. Then find the match of the fifth column in each sheet. Only if both the fourth columns and both the fifth columns match, then only must the sixth column be compared. If the sixth column does not match, an ERROR message must be shown. An email must be sent to me if data does not match. The sheets are always live as they are responses to google forms
I want to develop two user form on google sheets for my logistic company. Some text includes dropdown, summation and vlookup of other textbox. The form is to be printed in specific format.
I want to develop two user form on google sheets for my logistic company. Some text includes dropdown, summation and vlookup of other textbox. The form is to be printed in specific format.
I want to develop two user form on google sheets for my logistic company. Some text includes dropdown, summation and vlookup of other textbox. The form is to be printed in specific format.
Automating steps like filtering couple of columns and then deleting the filtered data. Then vookup a formula in specified cell range till end More details: What is the primary purpose of the script? Automating a process Do you have a sample excel file to work with? I do have the file, but it is in my laptop What level of expertise is required for this project? Intermediate
I have a spreadsheet with a schedule tab. The schedule tab lists the time that an agent is scheduled to go to break or lunch. The second tab is "time_taken" shows the actual time that the agent went on their break or lunch. I need a final sheet ...lunch. ....If there are more than 1 instance of an unavailable lunch or unavailable break -please use the first instance for by the agent for calculation purposes... Because the final report should subtract the time Scheduled from the time take. Ideal skills and experience for this job include: - Expertise in Excel and data analysis - Experience with INDEX/MATCH function or vlookup or whatever method works best - Attention to detail and accuracy in matching and comparing data - Ability to deliver high-quality resu...
In need each of the three primary categories (Federal, State, and City) various input areas (Status, Income Tax, and Marginal Rate) to pick up the correct table arrays in the respective tabs of the workbook. Currently they are all pulling from the Federal sheet, or so I think
I am looking for a freelancer to solve an Excel sheet for me. The main purpose of the Excel sheet is for data analysis. I require the use of VLOOKUP functions to ensure accurate data analysis. The level of data organization required is basic data entry. Therefore, I need someone who is skilled in using Excel for data analysis, and has experience in basic data entry.
I am looking for an Excel expert to help me with an advanced data analysis project. The main purpose of the project is data analysis and I do not have any specific preference for Excel function or tool to be used. The analysis is expected to be at an advanced level of complexity. The ideal freelancer for this project should have experience in advanced Excel data analysis techniques and be proficient in using Pivot Tables and VLOOKUP functions. Attention to detail and strong analytical skills are a must. This is the question text : employees provided when they originally applied for a job at the firm. For each employee, the following variables are listed: Promoted (1 if promoted within 10 years, 0 otherwise), GPA (college GPA at graduation), Sports (number of ath...
I am looking for an experienced freelancer to build an Excel template for inventory management. The primary purpose of the template is to use vlookup with advanced filter and hide function for data scanning to extract unscanned items from the list. The ideal candidate should have the following skills and experience: - Expertise in Excel - Experience in building inventory management templates - Familiarity with vlookup, advanced filter, and hide function - Ability to work with a specific data format provided by me - Intermediate level of complexity in the template If you are interested in this project, please provide examples of similar work you have done in the past.
Hello! I'm in need of immediate help with a small adjustment to an existing spreadsheet. I have some specific instructions and guidance to provide, and I need this to be done as soon as possible. I'm looking for someone experienced with Excel who can help me find the best solution quickly. It should be fairly straightforward and should be a quick solution. If you think you have the skills ...I've attached a screenshot to demonstrate my problem. Basically I am trying to find a formula that will map postcodes to the required zone. The postcodes and ranges are in column A, the zoning value is in column B. I simply want to be able to enter in a postcode, and get the correct zone from column B. See screenshot. The issue is that the hyphenated values are not allowing me to use...
I'm looking for help by an experienced formula user with a...viewable against the corresponding date when selecting the relevant month from the list. To make this work I need further assistance with my if/iferror/vlookup/indirect formulas which are inside the white cells of the calendar.. They are about 90% correct, I am still learning so I still have some gaps of knowledge I also require the formula to replace any 'false' values shown which are days not relating to the month being viewed, this will be via an IFERROR. If there is a way to shade out these false boxes to a light grey for example that would be ideal. If you have expertise with complex formulas such as IF, INDIRECT, IFERROR, and VLOOKUP, please get in touch. Further details on the project can be...
What to learn Vlookup and understand how to integrate pivot tables/charts
Help with creating a sumif or vlookup formula. Multi worksheet excel document recording transport/haulage dockets. I need the formula to search for 2 lots of criteria in a seperate worksheet and then sum the values (tonnes).
I need help with a VLOOKUP formula on a Google Sheet ASAP. I'm looking for an experienced freelancer who is able to work quickly. The sheet I need help with is for data entry purposes. The project should include creating a VLOOKUP formula, so I'm looking for someone who is knowledgeable in Google Sheets and familiar with VLOOKUP in particular. I need someone who is reliable, skilled, and able to work quickly and accurately. If you think you're the right fit for this project, please apply! I am trying to write it my self, all my previous VLOOKUP work, but not this one! There is something wrong and it's simple and should take a few minutes only.
I have 2 worksheets and i am trying to find if the values from one worksheet match the other in terms of accounts and data. I tried to do a vlookup but unable to find the values that helps me find if the values between the 2 worksheets is the same when associated with the corresponding accounts.
...project that can automatically track time and generate invoices. The ideal candidate should be well-versed in commonly used Google Sheet functions such as the =QUERY() function and be able to work with external sources of data, if and when necessary. The main purpose of this automation project is to automate the invoice generation process and streamline the tracking of time. The ideal candidate must have a deep understanding of the =QUERY() function and the ability to use =Importrange() and =VLOOKUP() functions, as well. The project may require the use of external sources of data, either in the form of an imported file, or as an online database which needs to be queried. If you feel you possess both the technical capabilities and experience to successfully compl...
Hello! I am looking to hire a freelancer to help me with a project involving the creation of tally prime ledgers. I have excel sheet with parties gst numbers with address and contact details and excel with my previous year bill details. I want you to create a company in my name with my details in tally prime, I will share the details! I want you to vlookup in gst numbers sheet and add gst numbers to my previous year bill details and create ledgers for them in tally prime. To add the address of the customer you have to check gst site and update the address. Also I want you to customize the invoice in tally prime according to my need! It is enough if you add the customers mentioned in bill track file only . you can ignore the other additional parties which are there in gst p...
I need it to where when someone inputs an item number, the corresponding product number will auto-populate
Creating conditional formatting for multiple columns in different sheets Incorporating Vlookup for multiple columns Add date filter in sheets for getting the data as per day or month We should get Average Monthly Unit Consumption in Sheet for last month Automatic Hide Data more than 30 days old.
Hi, need some help to do arrange some data in certain format where there is some vlookup and filtering. This has to be done in VBA code in Excel.
Brief: -Produce a report on Adult's shoes performance for the date range 26th-30th of March 2021 -Identify the top 5 products by revenue for each gender (male, female, unisex) SQL Query: Using the “with” construct, write a query to pull the necessary data from the tables performance data and product data (attached). Excel: LARGE, VLOOKUP, Max if functions Joining and aggregating the data together and filtering to match the conditions in the brief. PD: there is not acess to database, it is only an exercise.
Looking for an Excel Expert to help with Spreadsheets Formulas, functions, tables, graphs Vlookup, match, IF, Concatenation, multiple Vlookup queries, plus other advanced Excel formulas Thankyou
Need to remove duplicates in a self colums E,F G ,H I 1. REMOVE DUPLICATES IN COLUMN E F G H I 2. INSERT A NEW COLUMN NEXT TO E 3. USE V LOOK UP BY PYTHON SCRIPT 4. REMOVE ALL #NA AND IN H COLUM REMOVE #NA AND 0 AND REMOVE THE NEW INSERTED COLUMS ANYONE INTRESTED CAN REACH ME. POST THE DISCUSSION WE WILL CONNECT ON GOOGLE MEETS AND DISCUSS IN LIVE SHEET FOR BETTER UNDERSTANDING
Need a small help with the Excel Vlookup
I need a quick solution for my Vlookup function. Only new freelancers can apply for this project.
Hi, I have a large database on MS Excel (30,000 rows) and I get new results daily in which I need to see if this data is within the database. I am aware that vlookup function does this, but need some assistance)
I have a workbook with data in 2 sheets, I need lookup on one column and returning value to another. Workbook is titled "KlixFinalin Progress" I need stock code copied to sheet titled "Klix Test" next to correspondning ID .
Hey Folks, This is excel report which extract data from 5 different sheets and map using Vlookup.
Looking for somebody whonis well proficient with excel particularly vlookup ..
Hi I am freelancer with paid account but not yet got any project I am advanced excel Expert, Cleaning of excel files VBA, Vlookup PDF editing with good typing speed . How to get projects please guide me.
VLookup ,Hlookup Match .. so that the values link up both the sheets..
...looking for ................... and I am excellent in the technology required . I have 20+ years of experience in development designing large-scale customized solutions. With Excel I have all th expertise as below: Excel VBA Excel MACRO Excel Automation Cell function (Custom or Excel's) User forms Charts and graphs Pivot Table Excel Dashboard Apply formulas/Advance Filter Vlookup / Hlookup Countif / Countifs Sumif / Sumifs Data Validation Conditioning Formatting Dropdowns I have started to work as a freelancer recently and I am offering my services for affordable prices. I would like to discuss your project in detail; we can set up a meeting, please let me know your availability Regards, Ben Gebol...
the following cells in the main cost sheet tab require the following simple formulas entering. Cell U17 - If formula (if cell G17 shows "yes" it will return value in cell W18, if cell G20 shows "No" the reurned value is 0 Cell U20 - If formula (if cell G20 shows "yes" it will return value in cell W21, if cell G20 shows "No" the reurned value is 0 Cell U82 - vlookup (depending on the value in cell Q83, vlookup should look at table on costings tab L2:M15, it should look in column L to see the closest number rounding up, then when found returns the corrsponding value in column M Cell U85 - If formula (if cell i85 shows "upfront" it will return value in cell Y85, if cell i85 shows "spread" the reurned value is 0 Ce...
