Excel formula help need onetomany vlookup type of formula jobs

I'm seeking an experienced clay artist specialised in creating sculptures based on photos. Exhibit depth in recreating intricate details from the photo in...sculptures based on photos. Exhibit depth in recreating intricate details from the photo into the sculpture. Ideal skills and experience would include: - Detailed knowledge of working with clay to create realistic sculptures - Proficiency in interpreting and replicating intricate details from photographs - Ability to work efficiently and with precision, paying close attention to my specific requirements for the project - Prior experience in photo-based sculpture creation would be highly advantageous. Your task will be to recreate a realistic sculpture from a provided photo. I value accuracy and attention to detail in thi...

I'm seeking a detail-oriented data entry specialist to input textual data from online sources into an Excel spreadsheet. Ideal skills and experience: - Proficient in data entry tasks - Experience with online research - Comprehensive knowledge in Excel Your role will include: - Gathering data from various online platforms - Inputting this textual data accurately into an Excel spreadsheet - Ensuring the data is properly formatted and error-free Please apply if you have a proven track record in similar projects. Accuracy and attention to detail are essential for this role.

Potential freelancers: -Past experience in financial services industry (Recommended) -Skilled in running excel VBA/macros, automating excel data & display through line chart Project: (1) Display recent weekly data (2) For past 5 years Key Details: (1) Data source:

I'm in search of an Excel AI expert to perform a variety of important tasks. The optimised individual should be highly skilled in data analysis, advanced formulas, and the production of automated reports. Role Duties: - Data Analysis: You'll be handling a large pool of data, which you'd have to dissect, sort, and interpret it into useful information for business decisions. - Advanced Formulas: We’d need you to utilise complex Excel formulas to help streamline our data processes. - Automated Reporting: Turn gathered data into comprehensive automated reports which will be consequential for business progress. Application Requirements: While an in-depth proposal has not been specified by myself, pivoting on your ex...

I'm in search of an Excel AI expert to perform a variety of important tasks. The optimised individual should be highly skilled in data analysis, advanced formulas, and the production of automated reports. Role Duties: - Data Analysis: You'll be handling a large pool of data, which you'd have to dissect, sort, and interpret it into useful information for business decisions. - Advanced Formulas: We’d need you to utilise complex Excel formulas to help streamline our data processes. - Automated Reporting: Turn gathered data into comprehensive automated reports which will be consequential for business progress. Application Requirements: While an in-depth proposal has not been specified by myself, pivoting on your ex...

AUTOMATED ANSWERING APP PROJECT APP NAME: D-BMB DEVELOPPING PLATFORM: React Native (without expo) DEVELOPPING STYLE: clear, clean and well written and readable code. Variables must be written indicating the type of the value (ex: strCallerNumber) FINAL RELEASE: we need a draft project where we will be able to add graphics and some more functionalities. Our target is to have from you a draft of the applications where the main functionalities will work fine as indicated. At the end is needed the source code that we can complete. This is an essential part or rather last money will be released when we can open and see that we can work on the code. MAIN FUNCTIONS: - The app must work in background mode and catch and check any telephone call arriving to the device ...

Hi I need a professional on excel api using VB language to import volume and open interest data from interactive brokers into excel sheet as real time data

I'm seeking a skilled and experienced SEO manager to support the redirection of 16 high value websites as we look to consolidate several legacy brand websites that have become part of the business through a successful M&A strategy to one core brand website across our EMEA business. For each website we need to ensure we migrate as much of the value that these legacy websites are generating today over to a different websites that currently drive less value. The value we are looking to migrate includes SEO ranking, traffic generation, lead generation, ecommerce sales, customer support and backlinks. Project Tasks: - Carry out performance gap analysis between website that will be redirected vs website that will remain - Perform a content gap analysis t...

I'm looking for an Excel expert who can automate a specific task in Excel related to formulas only need automation

I'm looking for an experienced developer who specializes in creating Google Spreadsheet plugins. The purpose is to import and export mixed data type including both text and numerical data. Key Objectives: - Development of a Google Spreadsheet plugin. - Integration for data from a web-based app. - Build up functionality of data import/export. Ideal Skills: - Experience in developing Google Spreadsheet plugins. - Proficiency in handling both numerical and text data. - Experience in integrating with web-based applications. The project involves developing a plugin for Google Spreadsheet that enables sharing specific spreadsheet data with our users, subject to their permissions. Upon sharing, users can view and potentially interact with the data. Additionally, th...

I'm seeking a skilled professional to help with the editing of visual content relating specifically to Construction. Further content may need to be filmed to make the ideal video so will need assistance with that too. - Task Focus: Main task involves fine-tuning existing visual content. - Industry Application: The edited content will be utilized in the construction sector. - Content Type: This project exclusively deals with visual data. Ideal Skills: - Proficiency in visual editing tools and software. - Demonstratable experience in editing visual content, specifically in the construction field. - Keen attention to detail and a strong aesthetic sense.

I'm...communication skills - Ability to provide examples of past work We need java Trainer at Andheri, Mumbai. Please share your resume, If jd is suitable. ------ Job Title: Java Trainer Location: Andheri, Mumbai Position Type: Full-time, Offline Contract Duration: 6 months Payment: 8,000 INR per day Working Hours: Monday to Friday, 10:00 am to 6:00 pm Training Schedule: - Training only on Monday to Friday - Trainers do not need to come on days without training - Some months may have as few as 15 days of training, while others may have up to 22 days Payment Options: (You can choose any one from below) - Daily payout at 8,000 INR per day OR - Monthly payout option available: 1,00,000 INR per month (maximum 22 days working) - Minimum 7 ...

...Bluetooth (BT) Beacon for ultra short bi-directional communications. The goal of this project is twofold: first, to discuss the feasibility and requirements of the app through a paid chat session, and second, to develop a tiny, well-documented demo app for iPhone that integrates with BT Beacon technology. Key Content: - Integration of BT Beacon to facilitate sending messages and receiving responses. - Implementation of asynchronous bi-directional communications using BT Beacon protocol. - Development of a test app allowing users to type text, send messages, and receive responses on-screen. Prerequisite Experience and Skills: - Proficiency in iOS development and familiarity with BT Beacon technology. - Strong understanding of BT communic...

I'm looking for a talented video editor to enhance my logo in a short, less than 1-minute video project. Key Requirements: - Create animation or motion graphics to bring my logo to life. The specific type of editing is up to your artistic interpretation as one was not specified. - Showcase your video editing skills by incorporating eye-catching transitions. Ideal Candidate: - You should have previous experience in video editing, specifically with logo animations. - Preferably, your application should include past work samples showcasing logos you've previously animated. - A detailed project proposal explaining your approach to this task would also be appreciated. In summary, I'm looking to bring someone onboard who knows how to make a logo engaging and me...

...and Excel, I'm currently seeking an experienced programmer to guide me through the process of calculating RPM. The core objectives of this project are: -to clearly presented on the g-forces the riders will be exposed to for each of the 3 speeds, whether the forces are enough to pin the riders to the walls, and the rpm of the most suitable ride speed For me, I am aiming - To understand the fundamental techniques of handling three sets of data through Excel. - To learn how to effectively import this data to MATLAB. - Finally, to produce a scatter plot representation of the imported data in MATLAB. This project primarily involves data from an experiment, so I'm aiming at gaining knowledge of not just i...

...with BT Beacon technology. - Strong understanding of BT comms and implementation in IOS apps - Excellent English and documentation skills The goal of this project is FIRST - to prove to me that you can deliver an tiny snippet of code to be used by another party (us). I do not want the code now , but to discuss with you for a small fee that what I want is or in not possible , if possible I will provide you a diagram of our needs and even code written for android that performs this function in a separate freelancer project. Today i do not know if its possible . That is my dilemma .. SECOND - The project There is no pairing in BT beacon protocol . We will be using ultra small packets In essence packets are no more than 30 bytes of data to send...

I need an expert in Power BI to convert raw financial data from Excel into insightful reports. - **Data Inclusion:** - The project involves translating Excel data related to revenue, expenses, and profit into Power BI reports. - **Data Update Frequency:** - The frequency of the data update can be discussed during the project initiation phase. - **Visualization Request:** - The desired output should be a series of simple financial reports, in table form. I'm looking for someone with a strong background in financial data analysis and Power BI. The ideal candidate would have experience in building informative reports, and the ability to transform complex financial data into clear and concise visualizations. - **Data Provided:** - Raw ex...

We're in need of a creative mind to design the new logo for our Recruiting Company. Here are some insights about what we need: - Logo Type: We need a combination of text and icon. The text should be clear and professional, while the icon should symbolically represent the essence of our recruiting services, something that speaks to our ability to connect great employers with talented candidates. Our Trademark is: SMF® The R in the circle ist important. Meaning: Schnell Mitarbeiter finden (bad translation for this => Fast Employer finding) Our URL: also writable in our Logo with Uppercase URL. - Color Scheme: We don't have any specific colors in mind. Be creative and we'll provide feedback that guides the final ...

I'm in need of an animated video creator to work on a project aimed at enhancing my brand awareness among general consumers. Key Project Details: - Video Type: The video should be animated. - Goal: The primary objective of the video is to raise awareness about my brand. - Audience: The target audience for this video is general consumers. Ideal Skills & Experience: - Proven experience in creating animated videos. - Understanding of brand awareness principles. - Ability to create engaging content for general consumer audiences.

We plan to sell multiple items on Opensea. A script using Opensea API might be the best option to create bulk seller listings. See . This project is to create the Opensea sale listing script. The sale listing information will be provided in spreadsheet format, such as: https://...using Opensea API might be the best option to create bulk seller listings. See . This project is to create the Opensea sale listing script. The sale listing information will be provided in spreadsheet format, such as: . Candidates must state which type of script they plan to use (Google Apps Script, Python, etc.). Thank you

I'm in need of a dedicated professional who can skillfully extract data from a targeted website, The project involves listing and comprehensive data extraction including: - Contact information - Company name - License type - Email - Full name - Mobile An efficient process of transferring this information into an Excel spreadsheet is required. Attention to detail is a must to avoid errors. No additional services like data cleaning or analysis are needed; the project is solely for data extraction into a spreadsheet. Ideal skills would include proficiency in data entry, web scraping, and Excel. Previous experience in data extraction would be highly beneficial. I'm seeking a freelancer who can work quickly without sacrificing data validit...

...have been implemented or used. This would provide proof of your ability to deliver on the project. Specifically, freelancers interested in this project should possess: - Expertise in Content Management System development. Prior project experiences validating your skills in this area will give you a solid edge over other applicants. - Proficiency in coding and tech platform adaptability, to cater for the initially unspecified platform or website. Your responsibility in this job will be to develop a seamless integration of the pay-per-post feature that provides a smooth user experience. This wouldn't just be about locking content behind a paywall, but also making sure the implementation doesn't disrupt the overall site experience. To excel in this project...

I'm seeking a talented 3D artist to create a precise image render of a car podium scene. The details about the car type and podium finishes weren't specified, hence the proficient freelancer should bring a creative approach to render any type of car (be it a Sedan, SUV, or Sports car) on a variety of podium materials with different finishes, which could include Glossy, Matte, or Metallic. Skills and experience in 3D rendering and design are paramount for this project. Though it wasn't explicitly asked, providing information on past work, relevant experience, and detailed project proposals would strengthen your application.

Hello there! I'm in need of a video editor well-versed in Kinemaster to help me out with my personal videos. Edit-Level: - It's not just a basic cut-trim type of job, I'm after someone who can provide intermediate level editing, which includes adding smooth transitions and captivating effects that can engage my viewers. Project Deliverables: - For the final output, I'm looking at receiving the project in MP4 format. Skills and Experience: - I appreciate if you have prior experience of processing personal videos with rich storytelling. - Proficiency in using KineMaster is a must. - An eye for detail and ability to enhance visual appeal using transitions and effects is important for me. Looking forward to an exciting part...

I'm seeking a WordPress professional with a sophisticated sense of design who can help me bring my site to its full potential. This project will involve: - Customization of my current themes to achieve a professional, modern aesthetic. - Installation of necessary plugins to enhance website functionality. - Creation of custom post types to refine my content presentation. Completion of the part finished site Ideal skills: - WordPress - Aesthetic understanding - Website Design - Website Development - UI/UX design The website is around 85% complete on design – some updates and general tidy up needed – internal pages will mostly need to be redesigned You will have a 100% understanding of how to set up a multi-vend...

I'm in need of a dedicated freelancer to assist me with some simple data entry tasks. The data involved will mainly comprise of basic information such as names and emails which will be provided in a digital format, mostly in PDF or Word documents. Requirements: - Proficiency in Excel for data entry - Attention to detail - Ability to meet deadlines This job would suit someone who is meticulous and enjoys structured work. Experience with data entry and Excel would be a big plus.

I'm looking to buy your existing, unique projects, mobile app, and software projects. I'm particularly interested in projects that stand out and have unique appeal. I am open to a variety of project types - it could be a website with an innovative design, a mobile app with unique features, or software that has a niche use case. Don't be afraid to offer up your project, even if you think it might not fit the typical mould. I am willing to consider a wide range of possibilities. I would be very interested in modern technology that will be useful in todays world which could relate to AI (artificial intelligence). Please do not send me pre written messages. Send me your projects that you have to offer, the price & the link to view. I will contact you as ...

The work is fairly straightforward: * Take a screenshot of the specific pages. * Manually types the information from specific parts of a webpage * Save text into an Excel file * Regular updates - every 12 hours (10AM & 10PM)

* Take a screenshot of the specific pages. * Manually types the information from specific parts of a webpage * Save text into an Excel file * Regular updates - every 12 hours in a day (10AM & 10PM) *USD 15 per month.

Change the data type for field. (Able auto increment)

I'm looking to translate an excel spreadsheet to an easy-to-use Google Sheet. - Conversion: Translate the full content of the Excel spreadsheet to Google Sheet without compromising the quality or missing any data points. - Functionalities: Ensure all formulas used in the current Excel sheet work perfectly on the Google Sheet. - Logo Placement: Importantly, I want my logo positioned in the top-left corner of the Google Sheet's header, maintaining its clarity and visual dominance in the design. The ideal freelancer for this task would be someone with extensive experience in Excel, Google Sheets, and graphic placement. Practical knowledge of maintaining spreadsheet functionalities during a transition is critically essential.

I require an experienced data entry freelancer with a strong proficiency in Excel and Word. The project entails translating text data from Word documents into Excel. The data is organized in tabular form in the word documents. Key Skill requirements: - Advanced level competency in Excel and Word - Attention to detail to ensure no data discrepancy - Speed and accuracy Experience in similar projects would be an added advantage. This job would suit someone who excels at meticulous organization with a knack for data structure. I await your bids.

I need a developer to create a Wix application that integrates data display features while maintaining a minimalist and clean aesthetic. The specific requirements of this project are: - The application should display specific customer data, class data, and rental data - The application should provide live updates and real-time data - It should have sorting and filtering options for the data display - Customizable data visualizations should be incorporated for users' easy and comfortable navigation The ideal candidate for this project should have strong experience and skills in developing with Wix and Wix Apps, SQL and integrating them cohesively. Understanding the importance of data management and the ability to integrate real-time updates into a simple yet fun...

I am in need of detailed-oriented individuals who can manually extract text and images from specified sections of a website. This data should be compiled into an Excel file and extracted every 4 hours. The work is fairly straightforward: * Take a screenshot of the specific pages. * Manually types the information from specific parts of a webpage * Save text into an Excel file * Regular updates - data should be extracted every 4 hours and sent to me everyday The ideal candidate should be meticulous and reliable, with excellent time management skills. Familiarity with Excel and basic data extraction methods is also required.

I have code for login trading accound and fetch token data. I need to update code to my system. you can create new code for my requirement at same cost.I need to collect live data from the web and candle stick with different time frame.I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Stock Broker account: If Buy signal find it will automaticlly place Buy order,etc., Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agre...

I'm in need of a highly skilled developer, with a deep understanding of Cosmos SDK to build a custom Blockchain for me. Specific Requirements: - First and foremost, the Blockchain must support smart contracts, this is the key functionality I require. - I have opted not to specifics on the type of smart contracts at this time, this can be further discussed during the project development phase. Project Timeline: - I need my project completed within a month, hence swift and efficient service is essential. Ideal Candidate: - An expert in Cosmos SDK. - Extensive experience in building custom Blockchain. - Understanding of smart contracts in Blockchain. - Good communication skills, be able to work within set timelines.

I am seeking someone to help me check and complete a trial balance statement (in Excel) so that it balances (or ensure there are no main missing items on it). There are only a few items that are unresolved. I can provide data of income and expense transaction (as needed) in summarized form, including Income Statement, detail of tax filing, bank statement etc. Data will be anonymized (i.e. staff, customer and supplier names concealed) for privacy reasons.

As an employer looking to test the excel proficiency of job applicants, I am in need of a freelancer to create an advanced level excel test. This test should accurately assess applicants' skills in the areas of formulas and functions, data analysis and manipulation and formatting and visualization. Skills and Experience: - Profound experience with Excel including sound knowledge of advanced formulas and functions. - Prior experience in creating excel tests or educational materials. - Strong understanding of data analysis/manipulation techniques. - Competency in formatting data and visualization features in Excel. The ideal person for this job has experience in creating similar proficiency tests and has an...

NEED THIS URGENT worked on it now in the next two hours. This video explain what needs to be done Attached is the powerpoint file And here is the original ai, that you can take images from it in better quality:

I'm in need of a reliable freelancer to help me automate the daily backup of my PHP table data to an Excel sheet. The primary purpose of this task is to ensure that all the data on my PHP table is safely stored in an Excel sheet for backup purposes. The data includes important records that I can't afford to lose. The ideal freelancer for this project would have: - Proficiency in PHP and Excel VBA for automation - Experience in data storage and backup systems - Ability to ensure data integrity during the transfer - Excellent attention to detail to ensure all data is backed up correctly - Availability to set up and maintain a daily process If you have the skills and experience to complete this project efficiently and accura...

Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 7 Hours not more then this, i had the excel to work on just make this on new sheet

I am urgently looking for an experienced Telegram bot developer to create a bot. we need a telegram bot that will pull market data on all tokens from alcor exchange. We need this quite quickly and will need a setup config section for other users to set up in there channel -as the admin i can add any token to it i want from Alcor exchange -The option to add it channels but admin controls to activate it for said channel -channel users able to use commands and add the tokens they want to display -pull data on command - user would type token from alcor and will pull live data

...Instant monitoring of stock levels for efficient operations. - **Customer Relationship Management:** Understanding and meeting customer preferences and needs. - **Sales Reporting and Analytics:** Informed decision-making and strategic planning. **Payment Options:** The system should support both cash and credit/debit card payments for customer convenience. **Additional Features:** - **Convert Traditional Menu to Digital:** QR code enables easy access to the digital menu. - **Complete POS System:** Order creation from the counter. - **Order Management and WhatsApp Updates:** Updates for customers and restaurant staff. - **Flexible Ordering:** Options to place orders from the phone, table, or home. - **Auto Invoice Generation:** Invoices sent via WhatsApp. - **Customer/Order E...

Looking for a skilled freelancer to efficiently transfer 500 questions from Microsoft Word to an Excel spreadsheet. This task requires precision and attention to detail. If you have experience with data entry and are proficient in both Word and Excel, we'd like to hear from you. This is a straightforward project with clear instructions, offering flexibility and a competitive rate. Join our team and help us streamline our data management process.

I'm in need of a freelancer who has a vast list of verified dentist emails. This list should include the individual's name, company name, city, email address, and phone number. My main goal for this project is to utilize this list for a national level marketing outreach. Ideal Skills and Experience: - Proven experience in Email List Building, particularly in the dental industry. - Strong attention to detail to ensure the validity and quality of the email list. - Ability to work efficiently and deliver the list in an Excel spreadsheet format. Please only apply if you have a pre-existing, substantial list of dentist emails. The quality of the contacts is crucial for the success of my marketing campaign.

I have been developing a website for the past 6 months with a freelancer who was unfortunately the wrong person for the job. I have a bunch of Designs and Notes for what I am looking to build, but it would be easier to discuss in chat. You can view our FIGMA link to get an idea of what I am looking for Qualifications: Must be Full Stack Developer Must have Design Experience Must be a native English speaker

I need an experienced web developer who will build a custom website tailored to my specifications. The project will involve creating an informational website incorporating several features. Here are the specifics: Custom Functionality: • Informational pages - The backbone and main focus of my site. Site Features: • About Us section - This will provide visitors with a comprehensive view of what my business is about. • Team Bios - I want a section where information about the people behind the business can be displayed. • FAQ - A section that will detail answers to frequently asked questions will be required. Ideal Skills and Experience: For this project, you should excel in custom-built web development, have an understanding of info...

...business topics. It will be a business & brand growth within Entertainment I need someone that can come up with very interesting post ideas & articles for Look at their Instagram account to get an idea of the type of posts that they do. You are going to have to come up with posts like this. It can be: -Informative -Questions to the audience -Hypothetical scenarios to get their opinion -Comparisons  It needs to be articles & post ideas that non business lovers will be interested in engaging in! This is why its important to come up with topics that matter to pop culture fans. While writing this job description I came up with 8 articles & social media post ideas. These are the types of ideas you should come up with... 1. If $1,0...

I'm currently working with two Excel sheets for inventory data. I need help with applying VLOOKUP functions to these sheets. I need the correct formula to lookup the Sheet 1 Column A data, in Sheet 2 Column B, and apply Sheet 2 Column B data in Sheet 1 Column B - please see attached. Key Requirements: - Understand and implement VLOOKUP formula to connect data between the two sheets. - Ensure the VLOOKUP function is working correctly and efficiently. Ideal Skills and Experience: - Proficiency in Excel functions, particularly VLOOKUP. - Prior experience working with Inventory data is a plus. - Attention to detail and accuracy in data manipulation. Please reach out if you're confident in your Exc...

I need assistance with converting various Excel, Word, and PDF documents, making up a total of 32 pages, into a comprehensive and printable directory. Here's what would make you a great fit for this: - Proficiency in data entry and conversion between formats. - Strong skills in Excel, Word, and creating PDFs. - Experience in building and formatting directories. - A track record of delivering high-quality, print-ready documents. Key Tasks Include: - Collation and organization of information from different files. - Conversion of these files into a uniform, printable PDF. - Quality checks to ensure formatting remains consistent and ready for print. Please bear in mind, the final directory is not intended to be searchable. It should be ...