Vlookup formula in excelpráce

I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!

I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. W...show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel fil...

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

The website is designed primarily to serve as an informative platform about our services and broadcasting experience in the Free To Air sector. Information that needs to be conveyed on the website: 1. Detailed overview of the services we offer, outlining how we excel in the market. 2. Showcase our extensive experience in the field, driving confidence in our capabilities. The site will be mainly aimed towards potential clients and Free To Air broadcasters who are looking for reliable broadcast service providers. Ideal freelancers for this job should have proficiency in web design with experience developing informational websites for service-based businesses. Understanding of the broadcasting or related sector would be an advantageous, but not ...

I need a skilled Wordpress expert to address a migration issue I'm facing with ...server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP, theme and plugin compatibility issues. Your ability to troubleshoot and resolve migration issues will be crucial. I'm looking for a professional who can efficiently tackle this issue and ensure a...

I'm in need of a diligent and reliable virtual assistant to assist me with a range of tasks. Here's an overview of the key responsibilities and requirements: - Data Entry: The ideal candidate will be comfortable handling medium volume data entry tasks. This may include various forms of data manipulation, collection, and input. - Email Management: You'll be responsible for managing my email inbox. This includes reading, responding, and flagging important messages for my attention. - Appointment Scheduling: The role will also involve coordinating my schedule and setting up appointments. To excel in this role, you should have experience with: - Microsoft Office Suite, including Word, Excel, and PowerPoint. - CRM Software: Knowledge of Customer ...

...delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a must. Ideal...

I'm seeking an Airtable expert to assist me with a number of tasks, including data entry and organization, building custom workflows, and creating advanced formulas. Ideal candidates should have: - Pre...organization, building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experience working with Airtable, including data entry and organization, workflow creation, and complex formula design - A strong understanding of how to make the most of the tool, including its integrations and automations Please note that while my exact requirements in terms of the number of tables and views in my Airtable base, as well as specific integrations I need, have not been stated, I expect the freelancer to be able to adapt to my needs...

Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards. Develop a bespoke Microsoft Excel spreadsheet to accurately calculate sales commissions. The specifics: - The variables: the spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined accurately according to custom formulas (using the previous variables) that considers the Commission Percentage. - Data input: The spreadsheet will be easy to use, allowing to manually input the data for calculation. This tool (Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards) will enhance efficient determination of commissions, hence accuracy and precision are paramo...

...information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamlessly integrates with our existing customer service processes. The above was generated from Freelancer. Below is more information in my words: I h...

I am looking for a skilled developer to crea...contact information The system should enable me to sell, update, and manage chatbots with ease. On the flip side, my clients should be able to access their chatbots through a login and utilize them effectively in both English and Spanish. Additionally, it is essential that the chatbot can integrate and be used on social media platforms like Facebook, Instagram, or WhatsApp. It should be easily configurable for clients and capable of pulling data from databases, Excel, or Google Sheets. Ideal candidates for this project should have a strong background in software development, particularly in AI and chatbot technology. The ability to create a user-friendly interface is crucial, as the goal is to make the system acces...

I am in need of an expert who can assist me with the customization and setup of Microsoft Office applications. Key responsibilities: - Assessing my requirements and suggesting the best ways to customize the Microsoft Office software. - Configuring the settings and options of the software to meet my specific needs. - Providing step-by-step guidance to help me understand and use the customized features efficiently. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (Word, Excel, Outlook). - Experience in customizing and setting up Microsoft Office applications for various purposes. - Excellent communication skills to explain technical information in a clear and understandable manner. Your assistance would be greatly appreciated.

I require a clean and professional logo for my project management consulting business, Let’s Sort This Out, LLC. There isn't any specific imagery I am tried to, perhaps incorporate a pen, clipboard or excel style doc - I am 100% open to creative suggestions! Ideal designers will be experienced in corporate branding and able to present a portfolio of similar work.

I'm in a rush and need a skilled designer with experience in 3D Max and AutoCAD for an urgent architectural project. The main focus of this task is the detailed design phase. I need you to take concepts and transform them into detailed plans, elevations, and sections. There's a deadline to be mindful of, as the completion is needed as soon as possible. Key responsibilities include: - Translating architectural concepts into detailed designs - Creating detailed plans, elevations, and sections - Ensuring the design meets all necessary standards To excel in this project, you should have: - Proficiency in AutoCAD and 3D Max - A deep understanding of architectural design principles - Experience in detailed architectural design - The ability ...

...generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer information. - Edit Old Quotations: Users should be able to access and make changes to previous quotations. - User Management: The system will need to support 1 admin user with the ability to add unlimited users. The admin should have visibility over all user data. Ideal skills and experience for this project include: - Strong knowledge and experience in Android app development, possibly with PC based development skills as well. - Proficiency in creating apps with offline functionality. - Prior experience in developing quotation, invoicing, and tax receipt system...

K zobrazení podrobností se zaregistrujte nebo přihlaste.

I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward to receiving your proposals!

I'm looking for an experienced financial analyst with expert-level MS Excel skills to provide a comprehensive understanding of the data and help build a comprehensive energy financial model. Key Deliverables: - Explanation of Cash flow projections - Explanation of ROI calculations - Explanation of Sensitivity analysis - Explanation of 5-year financial projection - Explanation of Manufacturing Financial Feasibility Modeling Data Inputs: - Revenue projections - Cost projections - Investment costs - Tax rates Inflation Handling: - Inflation should be included in the projections Ideal Candidate: - Proficient in MS Excel, capable of building complex models - Experience in financial modeling for the energy sector - Understanding of...

نحن شركة تجارة إلكترونية نتعامل مع منتجات متنوعة ونبحث عن مدير إعلانات الوسائط الاجتماعية للانضمام إلى فريقنا. تشمل المهام على سبيل المثال لا الحصر: إنشاء الإعلانات على منصات التواصل الاجتماعي المختلفة إنشاء تقارير في Excel وGoogle Sheets بشكل يومي وشهري إيقاف الإعلانات التي لا تقدم عائد الاستثمار المقبول إنشاء إعلان جديد للحملة المتوقفة يجب أن يكون مدير الإعلانات متفرغًا فقط لهذا المشروع وغير ملتزم بأي مهمة أو وظيفة أو دراسة أخرى ساعات العمل: 6 أيام في الأسبوع، 10 ساعات يوميا يجب أن يجيد الوكيل اللغتين العربية والإنجليزية يجب أن يتمتع أيضًا بمهارات تواصل جيدة يمكن أن تعمل على إكسل أن يكون لديك خبرة كافية في إعلانات وسائل التواصل الاجتماعي والتسويق الرقمي

As we are Manpower Supply Agency, We would like to incorporate attendance day to day entry of our workers from this info we would like to automate payroll, billing and Government salutatory. and also a dashboard for overall performance of our agency. Skills and experience: - Human Resources and Employee Management expertise - Ability to create user-friendly interfaces - Experience with Single Sign-On (SSO) integration and other login methods - Capable of adding features like search functionality, photo upload, and editable fields - Excellent communication skills to understand our needs and translate them into a functional system.

...communications agency based in London, specialising in public affairs, policy analysis, media relations, and crises communications. We also organise events on behalf of European trade bodies including an annual awards ceremony for a leading sports nutrient association which takes place in London. We are looking for an experienced Event Organiser to provide essential administrative and logistical support for the team in the UK and EU either on a freelance or fixed term contract to deliver an awards ceremony in London in December 2024. You will need a positive, can-do attitude, and be able to flex your approach and make decisions at speed when required. You will perform well under pressure and possess great attention to detail. This is...

I need help with data entry from PDFs into Excel, with some basic analysis required post-entry. Key Details: - The primary task is to type data from PDFs into an Excel spreadsheet. - I will provide the PDFs, they contain various types of information that need to be accurately transposed. - The data must be organized neatly and consistently in the Excel file. Data Analysis: - After the data entry, I will need basic analysis of the entered data. This includes simple calculations, averages, basic graphs, etc. - A grasp of Excel's basic analytical functions is essential for this part of the project. Desired Skills: - Proficiency in data entry, especially from PDFs to Excel. - Strong command of Excel, particularly for data management and...

I'm seeking someone to migrate the content of a PDF DMS 5 book into an Excel spreadsheet. The Excel sheet should serve as a functional checklist with the disorder's name and its description only. Your mission is to categorize the disorders by chapters, mirroring the structure of the original DMS 5 book. Ideal Skills and Experience: - Proficient in data entry and Excel. - Organizational skills to categorize content effectively. I'm not looking for additional columns for notes or references, just an accurate transfer of the book's content to a checkist format de check list to facilitate reading a and diagnosis. Please apply if you're confident in your knowledge of this area and have the appropriate technical skills.

We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks i...and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in ...

I need assistance with extracting specific data from a voter list that comes in PDF format from the election commission. Here’s what I need: - Extract Name, FathersName, Age, Gender, VoterID, and SerialNumber from the PDF voter list. - Placement in a standard Excel format is acceptable, no need for any specific formatting. - Not just a one-time service, I also need a software or script that can perform this PDF-to-Excel conversion automatically in the future. Ideal candidates for this project have advanced skills in data extraction, familiarity with handling election data and proficiency in developing an automated system for convenient PDF to Excel conversion.

I need a professional adept at advanced Excel functions to create a spreadsheet, which would organize and manage our worker rota for late shifts from Monday to Friday. We have two sites, including inpatient and outpatient pharmacies, which need coverage. Key functionalities of the required Excel Spreadsheet: 1. Worker Availability: - The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writ...

I'm in urgent need of an experienced thumbnail creator to generate striking, vibrant thumbnails for various platforms such as YouTube, websites, and social media. *Style and Theme* Your designs should exude a colorful theme that's enticing and eye-catching. *Thumbnail Content* Each thumbnail should have captions incorporated in the design. The text should be readable without distracting from the overall appeal. To excel in this project, you need to be a skilled designer with a knack for creating visually stunning and colorful thumbnails. You should also have practical knowledge of designing for different platforms, and understand how to incorporate text seamlessly into your work. Past experience in a similar role will be advantageous.

I'm looking for a skilled front end developer to help me create a dashboard focused on data visualization,The primary objective of this project is to develop a robust data virtualization tool capable of interpreting, displaying, and analysing collision avoidance system data extracted from log files. This tool will enable users to load log files or Excel files, interpret the data, generate reports based on specified parameters, and visualise the insights using a web application or Power BI interface.

I'm looking for a skilled front end developer to help me create a dashboard focused on data visualization,The primary objective of this project is to develop a robust data virtualization tool capable of interpreting, displaying, and analysing collision avoidance system data extracted from log files. This tool will enable users to load log files or Excel files, interpret the data, generate reports based on specified parameters, and visualise the insights using a web application or Power BI interface.

I need a skilled Excel user to help me format a single spreadsheet and create formulas to automate some calculations. Key Responsibilities: - Format the spreadsheet to make it visually appealing and easy to read. - Create formulas to automate calculations based on the data input. - Ensure the spreadsheet is user-friendly and easy to update. Ideal Skills and Experience: - Proficiency in Excel, particularly in data formatting and formula creation. - Prior experience in handling data-heavy spreadsheets. - Strong attention to detail to ensure accurate data processing. - Ability to work independently and deliver the project in a timely manner.

I am searching for a knowledgeable expert in Microsoft Excel who can assist me with a variety of tasks. Specifically, I require aid with formulas and functions, and formatting and design. More specifically, I need assistance with summation and averages, and VLOOKUP and INDEX-MATCH commands. The ideal candidate would have substantial proficiency and experience with Excel, with an emphasis on utilising complex formulas and creating aesthetically appealing and comprehensible spreadsheets.

...an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formu...

I'm looking for a professional email marketing agency that can manage an email campaign for me. Essential skills/experience required: - Proficiency with email service like mailchimp or similar - Previous experience in email marketing, particularly in promoting products - Ability to send follow-up email Key deliverables: - Sending out 350 emails using our email id - Creating and sending follow-up emails - Providing a detailed report on the campaign's performance Please note, I have a template for the emails already. I also have the database of the people to send out in excel format - company name, email, first name and last name - so it should be easy

Seeking a talented and creative individual to assist in designing a compelling, professional corporate PowerPoint presentation, with an objective of introducing my company to potential clients. This slideshow should primarily focus on my company’s products and services, demonstrating our competencies and capabilities effectively. Key Requirements: - Deep understanding of PowerPoint design, and good eye for attention-grabbing visuals - Ability to translate corporate and product information into engaging content - Experience in creating corporate PowerPoint presentations is a major plus Specific Elements: - The presentation should showcase our capabilities, the products or services we excel in. - While not necessary, a designer who can incorporate we...

I'm in need of someone who can help me with lead generation. I'm looking to target specific industries in the process and would like to focus on the following segments: - Manufacturing & Machine Industry - Energy Providers - Insurances - Webshops ALL COMPANIES MUST BE BASED IN THE COUNTRY OF SWITZERLAND. COMPANIES SHOULD BE OF SMALLER TO MEDIUM SIZE, IDEALLY BETWEEN 10-99 EMPLOYEES. The leads I'm interested in should be responsible for digital transformation, digitisation, or be a product manager/owner. In small companies, this might be the company owner/CEO. In a bit larger companies (e.g.> 50 employees), this could be a separate position, which could either have the title of "Digital...something" or the "Pr...

I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.

I'm looking for a skilled professional to assist with a data entry project. The aim is to input various contact details into a spreadsheet, with a range of essential and additional information. Key responsibilities include: - Entering Name, Email IDs, Phon...additional information. Key responsibilities include: - Entering Name, Email IDs, Phone/Mobile Numbers, and Website Links for each entry. - Including LinkedIn profile links, Other correlated details, and Remarks for each entry. Ideal freelancers for this project should: - Have a background in data entry. - Possess excellent attention to detail. - Be able to work efficiently and accurately. - Familiarity with LinkedIn and other social media platforms. - Experience working with data on spreadsheet platforms like Excel...

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

Deseo un sistema de ventas que me permita crear una base de datos para mis clientes , registrar inventario de bidones , registrar los pagos en efectivo Transferencia y los que deben , registrar compras , Cuento con un cuaderno con informacion de los meses de enero febrero y marzo quisiera ingresar esa informacion . Adjunto un formato de excel donde llevo prácticamente ingresando datos manuales , necesito llevar control de los ingresos y egresos

I'm in need of an Excel Calculation Expert. I have data spreadsheets that need to do the calculations using Excel Your primary task will be to: - I've dataset (excel file), that needs to do the calculation using excel - Once it done then you need to write report as per following requirement Deadline: 10 hours or less

I need an Excel expert to assist me with various tasks involving data analysis and calculation 1. I have data and you need to do the historical data 2. After that you are required to write report as per requirement and instruction 3. Deadline: you may take 8-10 hours

I am seeking a talented pop vocalist with a knack for creativity. This exciting project involves converting a poem into a song. Key Responsibilities: - Create a pop melody for a specified poem - Bring the poem to life through song. Ideal skills: - Previous experience in the Pop genre - Strong vocal abilities - Previous songwriting experience or ability to translate poetry into musical form. This is a fantastic opportunity for those who excel in conjuring up catchy pop melodies and are skilled at breathing new life into written words.

I need a data entry specialist to help me with a simple task of entering data into spreadsheets. Ideal Skills and Experience: - Proficient in data entry, specifically into spreadsheets, with a keen eye for detail - Experience working with Excel or similar tools - Ability to maintain accuracy and meet deadlines - Good communication skills and reliability Looking forward to working with a professional who can complete the task efficiently and accurately.

In this project, I need a freelancer who can meticulously manage data entry tasks. Ideal Skills: - Strong data entry skills, specifically with text data. - Advanced knowledge of Excel and data management within it. - Ability to understand and follow custom data organization instructions. Job Summary: - Enter text data into Excel format, understanding the importance of accuracy. - The data must be organized in a specific, custom order that I will provide. - Experience in similar jobs and a keen eye for detail will be highly beneficial.

I'm in urgent need of a skilled content writer who possesses strong proficiencies in Microsoft Excel. The primary task will involve generating written material for my organization, with an additional responsibility requiring accurate invoice creation. Your responsibilities in detail: - Generate compelling content that aligns with my organization's goals and objectives. - You would also be responsible for creating invoices using Microsoft Excel. Ideal qualifications and skills: - A strong grasp of the English language with excellent writing skills. - Prior experience with content writing and invoice creation. - Expert understanding of Microsoft Excel, particularly when it pertains to invoice creation.

...GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotal...

...looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - E...

Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. Looking forward to your propo...

I'm in need of a seasoned freelancer who can help design a professional and engaging newsletter targeted specifically at newby freelancers. This is a recurring project, and I require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make the newsletter visually appealing and professional. - Audience Focused: The content of the newsletter should be tailored and engaging for experienced freelancers, providing them with valuable insights and tips that can help them excel in their freelance careers. Ideal Skills and Experience: - Proven experience in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools for managing and...