Excel formula help need onetomany vlookup type of formula jobs

I'm in need of a skilled branding professional who can craft an all-encompassing brand guidelines document for my pet grooming business. This document will serve as a comprehensive resource for our marketing partners, ensuring consistent color usage across all our promotional materials. Key Elements: - Color Palette: A definitive selection of colors that best represent our brand, along with the specific color codes. - Logo Usage Guidelines: Clear instructions on how our logo should be applied, in terms of size, placement, and when alternative versions can be used. - Typography Guidelines: Detailed information about the fonts and typography style that should be used in all our communications. - Merch Guides: Design suggestions and guidelines for any promot...

...creating a custom carrier board that is specifically designed for Raspberry Pi Compute Module 4. Features: - It should include an Ethernet - Type-C USB port power power. - We're also looking at equipping it with a 4G mobile module (SIM7600 or equivalent that work in Australia/Telstra). - 1 X Sim slot. - 2 X External antenna connectors SMA - 1 X Power LED for CM4 - 1 X Activity LED for CM4 - 1 X Multicolour LED for signal strength of mobile module. - The carrier board should be made as small as possible. Skills and experience: - Freelancers interested need proficiency in electronics and PCB design, along with a deep understanding of Raspberry Pi Compute Module 4. Experience in custom carrier board design and SIM7600 or equivalent 4G mo...

...professional who can set up an Azure data storage account to store Excel data, particularly with the following key features in mind: - **Data Type and Source**: The data I'm working with is primarily Excel based, so having experience with managing structured data storage in Azure is a must. - **Frequency of Updates**: The data will be updated on a weekly basis, so the storage solution needs to seamlessly accommodate this. - **Purpose of Storage**: The primary purpose of storing this data in Azure is for data analysis. While not the only use, ensuring that the storage solution allows for easy and efficient data analysis is crucial. The ideal candidate should have prior experience with Azure data storage, particularly in managing Exc...

Job Title: Remote Project Manager for Media Project Location: Remote Company: 1TV Media Job Type: Full-Time Overview: 1TV Media is seeking an experienced Project Manager to lead a media-related project from a remote location. The successful candidate will be responsible for attending meetings, planning, strategizing, and managing all aspects of the project while working virtually. This position is ideal for someone with a strong background in project management within the media sector and experience working with nonprofit organizations and international donors. Responsibilities: • Lead project planning, scheduling, resource allocation, and project accounting. • Manage remote project teams to ensure compliance with project deadlines and milestones. • Co...

...Tasks: - Research: I need detailed information on black bean, focusing on quality differentiation. This includes the origin (country) of the beans, the type of packaging used, and the pricing trends. - Product Promotion: Your task would also involve helping me promote these beans based on the research findings. Ideal skills for this project: - Market Research: Prior experience in conducting market research, particularly for food products, will be an advantage. - Product Promotion: A good grasp of effective product promotion strategies will be necessary to help market these beans successfully. - Spanish: Spanish is essential as the research and product promotion will be primarily in Spanish. It's important for you to understand the languag...

...me. The main function of this program would be to detect and digitize human handwriting from forms, consolidating that information into an Excel sheet. There would be a subsequent function for field extraction to compile a final report. - Desired Skills and Experience: • Proficiency in OCR technology for handwriting detection • Experience in custom software development • Excel programming expertise for auto-consolidation of data • Knowledge of report generation mechanisms within software Successful execution of this task would drastically streamline data processing in my start-up. To increase accuracy, the OCR program needs to be trainable, in order to recognize unique handwriting styles of different individuals. ...

I have a simple flowchart in Excel that I need converted to DrawIO format. The purpose of this flowchart is for internal ISO 9001 documentation , so it needs to be clear, easy to understand, and look somewhat formal, so Font style and Color scheme should be appropriately chosen. I'm looking for a freelancer with experience in graphic design, particularly flowchart creation and DrawIO, who can give this flowchart a clean, professional look. The excell file will be provided to you, so you can copy/paste the text. I do not expect you to change the content. There might be additional flowcharts in the future, so potentially repeat business. When bidding, let me know whether or not you have experience with ISO documentation drafting, which might be a plus.

I'm currently in need of a professional photographer who specializes in product photography. The focus will be on capturing detailed, high-quality images of Dupattas, a type of clothing accessory. Key Requirements: - Adept at performing professional product shoot - Demonstrated expertise in capturing clothing items - Should possess an innovative yet detail-oriented approach to capture the essence of the Dupattas Ideal Skills and Experience: - Proven experience in Dupatta photography or related clothing accessories - Familiarity with contemporary style of photography - Strong portfolio showcasing the ability to capture the beauty, texture, and detail of clothing items This is a great opportunity for a photographer well-versed ...

I'm in need of a skilled individual who can accurately convert a complex PDF file into a Word document file type. Main Responsibilities: - Retain a specific format design during the conversion process, the details of which I will provide later on. - Pay specific attention to the special characters or symbols, and tables and graphs present in the document. Ideal Skills: - Proficiency in Microsoft Word - Detail-oriented - Excellent understanding of complex/special characters and table/graph conversions - Dependable, with a commitment to delivering moderate accuracy in the output You will benefit from having prior experience with similar conversions. Any advice regarding the process, based on your prior experience, is welcome. Your attention to deta...

I'm requiring assistance with a meticulous task of transferring text data from a website. The data on the site is neatly arrayed in table format, and I need someone to manually sift through and copy the specific fields of 'Name', 'Date', and 'Description' into an Excel file. Ideal candidate would have: - Excellent attention to detail - Proven experience with manual data entry - Proficient in Excel - Understanding of structured web content This task requires patience, a keen eye for detail, and expertise in transforming web data into organized Excel entries. Interested freelancers need to commit to high levels of accuracy to ensure all data transferred is error-free.

Project Deadline: 1 Day Project Budget: $45 Project Level: Standard Project Type: PHP Project Overview We are looking a simple but well written PHP script that uses the Google Places API to allow a user to search for a term, and then display the list of results on screen & allow a user to download the results in a CSV File Script will be using the following Google Places API Additional Technical Information Results must be limited to top 50 records. Script must be written for PHP 8.2 & above 5* FEEDBACK WILL BE LEFT FOR YOU

I am searching for a freelancer to copy-type content from print books into a Word Document. The job requires: - Typing skills to convert lengthy printed books - Knowledge of Word formatting: specifically aligning and indenting texts Previous experience in tasks of a similar nature and any proofreading skills would be a significant advantage.

I am looking for Excel experts who can assist me with creating formulas and functions within a week. I have wholesale mobile shop. I want excel works for example desboard in one sheets and custumer sheets which contain debit credit ,describtion and total amount one more important all costumer name on desboard and if debit or credit amount also show on desboard please also look for attect excel file

I am in urgent need of a skilled developer to build an e-commerce app using the WooCommerce/Opencart platform. Requirement details Core Concept: - 1. We will shoot WhatsApp SMS with our app link. (with third party option-no development required.) 2. Customer will sign up and login with Name & Mobile Number (OTP etc. verification required here.) 3. Customer will get Reward Points which can be redeem as per Product Purchase bases. 4. After login customer can do following: - See Products, Search Product, Add to Cart. 5. only Cash on delivery option will be there. 6. After receiving any order, it will reflect on Admin Dashboard 7. Admin/Operator will call on the given number and discuss for the delivery (offline) 8. Admin/Operator will mark Order done/reject/cancel. 9. If c...

I require an expert in Excel financial calculations to design a spreadsheet to calculate commission on sales. The main purpose is to drive commission payments based on a tiered structure. It will be used to manage commission payments linked to sales figures above a specified target. Ideal Skills: - Extensive experience in Excel spreadsheet design, particularly with financial calculations - Experience in tiered commission structure calculations - Strong understanding of financial data management. Responsibilities: - Design and implement Excel spreadsheet for commission calculations - Ensure accuracy of calculations based on the tiered commission structure.

We're looking for someone to help us design new style racing seat for our racing simulator. Unlike traditional racing seat which has a seat back and a seat bottom, we are looking for any creative designed to help us design a formula style racing seat. When designing the seat, we are looking to reduce the size of the packaging, so from manufacturing stand point, the seat needs to be disassembled into smaller pieces. I have attached a few example of similar seats that we're currently looking for. As for the framing, we can use either square, round tube, metal plate, and aluminum extrusion bars.

Hi Ishaq. Can you have a look at this app for us. We want to convert it from a commend line batch file to a GUI app in Python. We had one of our team build the app in C# a few years ago, but he has left and we have the source code. The app will extract an image from an excel spread sheet based on the column ref and put the image into a nominated directory with the imaged named as per another column in the source excel spreadsheet. I can send yu a full demo of the app. regards Rob

I am seeking a creative designer to craft a unique and engaging design for my IV bag. It will be used for medical purposes, so the design needs to be both professional and illustrative. Key Requirements: - The design must clearly indicate the medication type - It should be engaging and illustrative, while maintaining a professional look. Ideal Skills: - Graphic design, specifically in the medical field - Understanding of medical design standards - Ability to create engaging and professional illustrations

I'm in need of a skilled developer to assist with some intermediate level formulas and calculations on Google Sheets. I'm struggling to automate some repetitive tasks and I need someone with experience in this area to help me out. Key skills required include: - Proficiency with Google Sheets, particularly with its various functions like VLOOKUP, SUMIF, COUNTIF and others. - Understanding of how to automate tasks in Google Sheets. Your mission, should you choose to accept it, is to bring automation to my Google Sheets tasks, helping me reduce manual labor and making my life a lot easier. If you have a penchant for problem solving, this could be the perfect job for you!

I'm in need of a Standalone STM32 SWD programmer that can flash firmware without the need for connection to a computer. The programmer should be powered by a battery. The binary firmware files will be on a SD card with an XML file with the processor type to prevent it being loaded on an incorrect processor. The unit will have buttons and LED's to start the process and indicate the progress and supply 3.3v to the processor board There a number of projects on github that could be used as a starting point such as Key Requirements: - Stand-alone Programming: The system should be capable of flashing firmware into STM 32 microcontrollers without the need for a computer connection. - Battery Powered: I require the programmer to be p...

...website, using geolocation as the primary criterion, and collating the data of various companies into the excel spreadsheet I will provide. Key Tasks: - Browse the provided website and search explicitly based on geolocation. - The geolocations of interest are predetermined and are stated within my excel sheet. Data Collection: - Oddly, I do not require some common fields like company name, address, or phone number. - Ensure accuracy and completeness of data collated into the excel spreadsheet. Ideal Skills and Experience: - Proficiency in advanced web research and data entry. - Working knowledge of geolocation-based search - Attention to detail and a keen eye for accuracy Applications: - Please include details of your past w...

...TypeScript related. The primary problems seem to be troubleshooting-type script errors. Unfortunately, the specifics of the errors aren't known, so we need a developer who is expert at debugging and problem solving. Ideally, we are looking for someone with: - Deep understanding of Ethereum bots - Extensive experience with TypeScript - Proficiency in troubleshooting various TypeScript errors - Ability to identify and resolve undefined variable errors as well as syntax and type errors - Strong problem-solving skills in debugging Ethereum bots Unfortunately, we cannot provide a specific timeline due to the uncertainty surrounding the precise nature of these TypeScript errors. Thus, we need a freelancer who is flexible yet capable ...

I'm in need of a skilled data entry specialist, specifically someone with experience in Excel and online data entry. Key Project Details: - The task at hand is small and involves less than 100 records, so the workload is manageable. - Primarily, I'm looking for someone who can analyze the data rather than just inputting it. Ideal Skills: - Proficiency in Excel and online data entry tools. - Strong analytical capabilities. - Previous experience with similar, small-scale data entry projects would be an advantage. I'm eager to work with a diligent, detail-oriented freelancer who can ensure that the data is accurately inputted and analyzed.

I'm in need of an Excel expert to meticulously update the product descriptions and prices in my catalog. The requirements include: - Updating: You'll be tasked with updating the product descriptions with new information and ensuring all the prices are current. - Catalog Size: The catalog comprises over 500 products, so attention to detail and ability to handle large volumes of data is crucial. - Formatting: Special formatting is not required, the new product descriptions and prices need to be consistent with the existing entries. Ideal Skills & Experience: - Proficiency in Excel: Successful candidates should have a high level of understanding and experience with Excel, particularly handling large datasets and using for...

mailchimp integration email form help ENFOLD THEME Wordpress site

Hello, I am looking for an experienced MS Excel programmer to enhance and automate an existing Excel spreadsheet. The primary goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you hav...

...dashboard on Excel. The purpose of this project is to streamline our sales data for easy comparison and analysis on a daily, monthly, and quarterly basis. Key Features Required: - The ability to compare daily sales with last day's and last year's sales. - Monitor monthly actual vs budget vs last year. - Track quarterly sales performance. - Special attention should be given to the revenue growth metric. Ideal Experience and Skills: - Excel mastery - Proven experience in creating interactive dashboards - Knowledge in sales data analysis - Ability to create a user-friendly interface where data can be manually input efficiently and effectively Your role will heavily involve the organization of complex sales data into an easily navigable and compre...

...developers to take on an upcoming project. While the specific type of website is yet to be determined, it could be an e-commerce, blogging, or a portfolio site. As such, I'm looking for developers with a broad range of skills and experience in creating different types of websites. Key skills and experiences I'm looking for in potential freelancers: - Proven track record in website development: I'd like to see evidence of your past work and experience in creating websites of various types. - Versatile skill set: The successful candidate should be comfortable working on different types of websites, as we're still undecided on the exact nature of the project. - Good communication skills: As I'm unsure about...

I'm building a site in Oxygen with Advanced Custom Fields. I have created a custom post type with several different categories. I have then also created a custom archive template using a repeatable element. However, I can't get the archive template to display just the posts in the relevant categories. When I go to the front end categories, they either display nothing or all of them.

data entry (copy EAN code, SKU, and size) from label /image 2.300 label /image to Excel spreadsheet / google sheet file.

VBA EXCEL Bulk SMS Template

I'm looking for a competent Shopify developer to create and run a store for my clothing and apparel products. I'll be relying heavily on a drop-shipping approach for inventory management, so any experience or understanding of managing this type of inventory system is a plus. Key Skills Needed: - Extensive Shopify platform knowledge - Experience with drop-shipping setup - Ability to create engaging product displays - Understanding of inventory management The ideal candidate will understand how to effectively create a user-friendly store layout and have a keen eye for placing clothing and apparel items in a way that entices consumers. Please include any previous Shopify development and drop-shipping setup experiences in your bid.

I need a detailed Microsoft Excel spreadsheet that tracks expenses related to Hurricane Ian and deducts them from my current house appraisal. Key aspects of the project: - **Expense Tracking**: The spreadsheet should offer a detailed list of expenses. These should be categorized (e.g. repairs, replacements, labor). - **Formula Integration**: It should also include formulas that automatically calculate the sum of these expenses. Ideal Candidate: - Proficient in Microsoft Excel - Experience creating detailed expense tracking sheets - Familiarity with property appraisal processes and calculations Please submit examples of similar spreadsheets you've created in the past.

I have an assignment on System Hacking in CEH that I need urgent assistance with. Here's what I'm looking for: - **In-depth explanation of concepts**: I need someone who can break down the complex concepts involved in System Hacking in a way that is easy for me to understand. - **Practical Lab Exercises**: While I understand the theory, I need help with practical exercises that will help me grasp the concepts better. I am looking for someone who has: - A deep understanding of the CEH System Hacking module - The ability to explain complex concepts in an understandable way - Experience in teaching or tutoring in CEH would be a plus The deadline for this project is ASAP. If you have the expertise and availability, please get in ...

Desiring a unique appeal for my first home, I require a floor plan that captures the essence of modern Gothic architecture. The final design should be a fusion of timeless gothic elements with modern-day flair. Key Project Specifications: -*2 story home with space for a future elevator or lift. - Design Type: The project focuses on creating a residential Construction Floor Plan with 8 in. concrete exterior walls. Total square feet NOT to exceed 1400sf. - Interior wall will be using concrete blocks 4"W x 6"L - *Prefer Monolithic slab 1-2ft above ground level - Style: The design preference leans towards a modern Gothic style, combining sophisticated elements of Gothic architecture with modern design subtleties, open floor. - Room Count: The floor ...

I am seeking a skilled part-time accountant to assist with bookkeeping and tax preparation tasks. Key Responsibilities: - Handling Bookkeeping: Your primary responsibility will be to maintain accurate financial records using Excel spreadsheets and Tally ERP 9. - Tax Preparation: You will also be responsible for preparing our taxes, particularly VAT. Ideal Candidate: - Proficient with Excel spreadsheets and Tally ERP 9 for maintaining financial records - Experience in tax preparation, particularly VAT - Knowledge of accounting principles and practices - Excellent organizational and time-management skills - Ability to work remotely and meet deadlines Please note that familiarity with Saudi VAT regulations is crucial for this position.

I'm in need of an experienced and reliable financial professional to handle our bookkeeping tasks. Key responsibilities will include: - Regular, ongoing bookkeeping using popular software like QuickBooks or Excel. Ideal candidates should: - Have a strong background in bookkeeping and finance. - Be proficient in using bookkeeping software (e.g., QuickBooks or Excel). - Have a track record of delivering accurate and timely financial services. This project is about maintaining our financial records with precision and efficiency. It's crucial that the freelancer is able to commit to regular, ongoing bookkeeping tasks.

...functionality into the clinic floor flow. - Knowledge of the latest trends in commercial design, particularly in healthcare. Location Information: - The project is planned in Saudi Arabia. - The project spans over an area of 546 squared meters on two floors. The project will involve: - Creating a modern design concept for the clinic that aligns with the corporate logo. - Providing detailed floor plans (dwg and pdf formats), 3D renders, and material suggestions (excel format for each floor/room). - Ensuring the design supports a professional and welcoming atmosphere for both staff and patients. Timeline: - Project shall be handed over 30 calendar days after the Kickoff meeting date. - Project date inclusive of two review sessions. Upon award of th...

My project involves collecting all of my medical records from a variety of locations and consolidating them into a master excel spreadsheet. In summary, the records include patient histories, immunization records, various diagnostic results, lab results, radiological imaging, surgical history, vision and hearing tests, and dental records. Given the sensitive nature of this data, I would ideally seek out a professional with experience in medical data collection and health-related projects with experience accessing patient data from various portals. Tasks include: - Gathering required records - Converting these records into an Excel format - Utilizing a specific organization system for collation, based on my Excel template (attached) Intermediate...

As an Amazon Seller, I'm in dire need of a reliable Dropshipping Agent based in China. You'll be in charge of the purchasing, quality control, packaging, and shipping of home and kitchen products to my customers. - Product Type: The particular focus would be on Home and Kitchen products. Ideally, you have experience handling these types of products, understand their specifics and handle them appropriately. - Quality Control: Adherence to Amazon's Dropshipping policy is critical. This includes performing necessary checks and inspections as per the policy's guidelines. Prior knowledge of this policy and experience handling quality control per this guideline will be desirable. - Volume: Expect to deal with less than 100 or...

Hi, I have an excel file that contains 190 rows and 6 columns. I need someone to sort the data for me in a text file based on a specific required. Needs to be done now, in a short time frame. Type EXCEL at the beginning of your proposal if you understand the above. Proposals without it will be ignored.

I'm in need of a professional who can collate my medical reports into a comprehensive portfolio. The main tasks include: - Organizing by type: I want the reports classified by their nature, not by the date or condition. - Uploading to a website: The final output should be accessible via a private link on a website. Ideal skills and experience for this job would include: - Proficient in handling medical documents. - Strong organizational skills. - Web design or content upload experience. - Attention to detail in ensuring the final product is clear and easy to navigate.

...currently in need of a skilled professional who is adept with Microsoft Excel to assist me in a task that involves highlighting multiple cells within a spreadsheet swiftly. The key details of this task are as follows: - The data within the cells that require highlighting are textual in nature. We're looking to apply emphasis on particular pieces of text within the document. - The focal point of the highlighting is based on specific conditions. In this case, the cells should be highlighted based on containing certain text. Skills and experience required: - Proficiency in Microsoft Excel is essential. - Familiarity with conditional formatting in Excel to highlight cells. - Experience working with text-based data in Excel...

I need a skilled data entry specialist to help me transfer data from printed documents into an Excel spreadsheet. The data requires careful attention as it must be accurately and consistently entered. Ideal Skills and Experience: - Proficient in data entry - Attention to detail - Ability to consistently maintain data quality - Previous experience in similar tasks would be beneficial.

I'm in need of an experienced freelancer to add my physical products to my Woocommerce store. The selected candidate will need to: - Handle a range of physical products: My products come in a variety of sizes and colors, so experience with variable products in Woocommerce is a must. - Manage product information carefully: As I have a significant number of products, I will be providing the product information in an Excel/CSV format. The freelancer will need to ensure that this data is accurately transferred into the Woocommerce platform, including details on variations. Some products have 10 variables some products have 5, It's between 2-15 variables no more no less, If you understand all the above please type the...

I'm in need of a proficient developer with experience in both Excel VBA and Selenium to create a template that enables automated sending of bulk WhatsApp messages. The core functionality I'm seeking includes: - Automated WhatsApp messaging directly from Excel - Bulk messaging support: The capability to send out multiple messages at a time. The messaging content that will be automated is primarily related to the Products and Services information. The ideal candidate for this project should have a demonstrated history of working with Excel, VBA, and Selenium. Experience with similar projects relating to WhatsApp and bulk messaging automation would definitely be a plus. This will be a unique project with potential for ongoing wor...

I am searching for a freelancer to copy-type content from print books into a Word Document. The job requires: - Typing skills to convert lengthy printed books - Knowledge of Word formatting: specifically aligning and indenting texts Previous experience in tasks of a similar nature and any proofreading skills would be a significant advantage.

I'm interested in having an Excel template developed which uses VBA to automate the sending of bulk SMS. Major points of focus in this project are: -- Compatibility: The template should be compatible with Excel 2010, 2013, and 2016. -- Phone Numbers Input: I'd like to manually enter phone numbers from which the SMS will be sent. -- Message Customization: Depending on the requirement, both the same message may need to be sent to all recipients and different messages to each recipient. The ideal freelancer for this task should be proficient in Excel, VBA, and have experience in automation. Strong communication skills would be appreciated to better understand and implement the specifics of message customization.

We are looking for a couple of Flutter developers to join our team. This is a long-term opportunity for the right candidate. Type of requirements:- -Develop new applications -Modify existing/live applications -Submit to the play store and apple store Ideal skills and experience: - Strong knowledge and experience in Flutter development - Proficiency in UI/UX design and implementation - Ability to work within specified guidelines and meet deadlines - Strong attention to detail and ability to follow guidelines - Familiarity with the latest trends and technologies in mobile development - Excellent communication skills Please apply with a few references from your previous works. Thanks.

To help with list creating activities for our business, we are looking for a Virtual Assistant that is very organized and meticulous. Excellent research abilities as well as the capacity to collect and arrange data quickly are requirements for the perfect applicant. The main responsibility of this position is to assemble lists of possible partners, clients, or prospects according to predetermined standards. 1. Perform internet research to find prospective partners, clients, or leads. 2. Gather information and arrange it into structured lists based on predetermined standards. 3. Check the integrity of the data and confirm the veracity of the information acquired. Use a variety of platforms and tools to efficiently gather and handle lists. 5. Help...