Types of lookup in excel jobs

...highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length:...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant approvals. The Grant Writer MUST be Canadian or have the expertise and experience with the Canadian government, ideally living in Canada and speaks and writes English Fluently. They MUST specialize in IT/digital marketing/ ecommerce/employee hiring grants They MUST have a proven strong track record of total grants submitted vs approvals in the last year within Canada. They are responsible for findin...

I'm looking for a skilled Shopify developer to help me ...like a video showcasing the footwear to be included. Product Types: - The store will sell a variety of footwear including sneakers, sandals, innersoles and socks. Prior experience in setting up stores that sell these kinds of products will be an added advantage. Product Inventory: - Initially, the store will have between 50 to 100 products. Experience in handling medium to large inventory on Shopify is required. Ideal Skills & Experience: - Proven track record in designing and setting up successful Shopify stores. - Strong grasp of e-commerce, particularly in the footwear industry. - Experience with product search functionality, product recommendations and video int...

...create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual representation...

I'm in need of a Freelancer Bench Sales Recruiter who will focus on the IT bench sales for my company. Sr. Bench Sales Recruiter - Freelance (Commission Basis) Remote This is not a salaried position Need Senior/Experienced Bench Sales recruiters who can submit our candidates to Prime vendors and Direct clients. will pay commission per placement. This person can also bring in any other consultants on our payroll (Separate incentives for this) We don't need anyone who works on Job boards. Need someone with strong relationship in the market Job Types: Part-time, Freelance Ideal Skills and Experience: - Proven experience in IT Bench Sales recruitment is a must. - Strong network in the IT industry and access to potential cand...

...experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy ...

I'm looking for a savvy salesperson who can help sell machine blades designed for food processing in the USA market. It's a niche product category, so prior experience in the industry will be highly beneficial. Ideally, I need someone who has: - Familiarity with different types of machine blades and their applications. - An understanding of food processing machinery and industry requirements. - Previous success in selling industrial products, particularly in the USA. - A proactive approach, great communication skills, and a strong network in the food processing industry. This is a fantastic opportunity to leverage your industry connections and expertise in a novel product area. Let's get these machine blades cutt...

I'm in need of a skilled developer to build an exam portal web application. Key Features: - User Registration and Login: Implement a secure system to allow students to register, log in and access the platform. - Exam Creation and Management: Develop tools for examiners to create and manage exams. This should include the ability to set time limits, number of questions, and other relevant parameters. - Result Generation: Implement a function that will accurately calculate and display exam results to students. Additional Information: - The portal will only be supporting specific types of exams. - The ideal candidate should have experience with similar projects and be able to provide a secure, user-friendly and efficient solution. - The project...

...Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VB...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, p...

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

urgent php laravel for website and api mobile app development More details: What specific PHP/Laravel tasks do you need assistance with? Fixing bugs in an existing website Could you describe the types of bugs you've been encountering on the existing website? User interface issues, Database related problems, Functional errors in the code Are there any specific pages or features on the website where these bugs occur more frequently? Homepage, Login/Registration, Product pages; Checkout process

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I'm having a peculiar problem with 3ds Max where I can't seem to save my finished renders. There is no error message popping up, which makes it all the more confusing. I've tested other file types, and they save just fine; the issue only occurs with the finished renders. I need a freelancer with a strong understanding of 3ds Max, experienced in troubleshooting, and ideally someone who has encountered and resolved this issue before. It is critical to me that this issue is resolved promptly while ensuring no data loss - the integrity of my existing files is of utmost importance.

I need a proficient Google Ads manager to handle my campaigns. I'm looking for someone who can update, create, and manage my Google Ads campaigns on a weekly basis. The main goal of these campaigns is to boost my product sales. You should be well-versed in the following types of Google Ads campaigns: - Search campaigns - Shopping campaigns I need someone with the following skills and experience: - Proven track record of managing successful Google Ads campaigns - Strong analytical and problem-solving skills - Excellent understanding of Google Ads and SEO - Ability to create compelling ad copies - Experience in boosting product sales through Google Ads is a plus. If you think you're the right person for this job, I'd love...

...Twitter for the goal of converting sales. We use Adroll for our restargeting that you will need to manage, along with retargeting through social media. We have a product to market, and also three features of our product that we want to specifically market and target with specific ads. We have a list of customers that can be used for like audiences. Finally, we have some events that we want to target with Geo fencing - about two events per month We have creative done for several ad sizes, but no video yet. We have a graphics person on staff to provide additional jpg ads as you request, and are willing to pay for video ads. We also will provide headline and description ideas, but you will also have to use some of your own knowledge and testing to find the...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-fri...

...the number of interactions. We believe that the issue lies in the type of interactions considered when determining trends. For this task, we are looking for a professional who can analyze these complexities associated with Twitter's algorithm and adjust it to take into account a wider array of interactions. Ideal skills for this project include: - Strong understanding of Twitter's trending algorithms - Knowledge of the social media landscape, particularly Twitter - Experience with algorithm development and adjustment The end objective is to have our hashtag consider fan posts, official events, and all other types of interactions when determining its trend status. This should, in turn, increase the visibility and...

We need a dedicated customer support telecaller to act as a devoted link to both our existing and potential customers. You will be responsible for offering support for our services, responding to inquiries, resolving issues, and ensuring overall satisfaction. This role requires: - A proven track record in customer support roles, ideally over the phone - Confidence and skill in handling all types of customer queries - Knowledge of CRM tools - Exceptional communication and problem-solving abilities - Experience with service-centric businesses is a plus

... The primary purpose of the project is functionality over aesthetics. This bridge should be designed specifically for vehicular traffic, and it's crucial it accommodates both light vehicles like cars and motorbikes as well as heavy vehicles such as trucks and buses. The proposed design should factor in strength, durability, and traffic flow for effective usage. Ideal Skills: - Degree in Civil or Structural Engineering - Experience in bridge design and functionality - Knowledge in geometric designs - Proficient in design software - Understands load calculations for different vehicle types. Views of the three-dimensional model of the proposal that includes all structural and complementary elements (Parapets, shoulders...

More details: What is the primary reason for encrypting the Raspberry Pi 4 OS and inside files? Protect sensitive data What encryption level do you require for your sensitive data? 256-bit encryption Are there specific files or data types that need to be prioritized in the encryption process? Program and System Files

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should...

I'm looking for someone who can...3D renderings for my e-commerce project named Amirkhon. The specific type of rendering is not defined yet. Key project details: - I need a highly skilled and experienced 3D artist who can create visually appealing and high-quality renderings suitable for an e-commerce platform. - The renderings should be versatile, able to adapt to various product types. - Experience with e-commerce projects is a plus. - Deadline is flexible, but I'm looking for someone who can work efficiently and deliver quality work in a reasonable timeframe. Ideal Skills: - Proficiency in 3D rendering software - Strong portfolio showcasing previous 3D work - Experience in e-commerce projects a bonus - Ability to adapt to various product ...

I am in need of a Blender animator versatile in creating character animations, product animations and motion graphics. The purpose of these animations is for entertainment and thus, they are expected to be highly engaging, vibrant and visually captivating. The ideal freelancer would have: - Extensive experience creating different types of animations - A strong hand at producing realistic character animations - Adept at creating lively motion graphics and detailed product animations - A record of creating entertaining and engaging animations - Capability to deliver high-quality, polished work on time. These are the specifics for a successful project completion. If you believe you fit the bill, I look forward to viewing your portfolio and di...

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

I'm in need of a professional who can analyze comprehensive survey data and present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attach...

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

...component. The timeline for the project is within a month. Here are some of the functionalities that are required in the form builder section of the application: - Capability to add various types of fields including but not limited to: * Text fields * Multiple-choice questions * Date fields * Dropdown fields * Free text fields - Ability to add a feature to take photos and store them locally. Freelancer Experience. Blazor Server (targeting web) .NET MAUI Blazor Hybrid (targeting Windows and Android) The ideal freelancer for this project should have substantial experience in developing versatile mobile and web applications and a strong understanding of various form fields in user-interface design. Expertise in mo...

I have a series of PDFs with text that needs to be typed into an Excel sheet. The data is mainly textual in nature. Key Requirements: - Data Entry: You'll be responsible for accurately inputting the text from PDFs into the corresponding cells in Excel. Ideal Skills: - Proficiency in Excel: You should be comfortable using Excel and have experience with data entry. - Typing Skills: Fast and accurate typing skills are essential. - Attention to Detail: The data needs to be entered accurately to ensure the integrity of the information. - Familiarity with PDFs: Experience working with PDFs is beneficial. Please note, there are no specific formatting requirements beyond accurate data entry.

I am seeking to have a tool developed th...should be focused on a specific city, which will be revealed once the project commences. Use of Data: The scraped information will be primarily used for market analysis purposes. The data will be instrumental in helping me understand the dynamics of the rental market within the specific city. Skills & Experience Required: - Proven experience in data scraping, especially from websites like Airbnb and AirDna. - Brilliant understanding of how to work with different types of data, such as numerical and textual data. - Strong ability to tailor the tool towards scraping data from a specified geographical location. - Knowledge of the real estate or rental market would be advantageous. Your und...

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

As part of my project, I require a thorough analysis of the Sequential Search algorithm. Key Requirements: - An understanding and calculation of the time complexity under all cases: worst, average, and best. - Assessment of the algorithm when working with all types of list: sorted, unsorted, and randomized. The ideal candidate should possess strong problem-solving abilities, excellent mathematical skills, and a deep knowledge of algorithm efficiency. Proficiency in the use of mathematical induction to prove the correctness of algorithms is highly desirable. Your task will revolve around the comprehensive evaluation of the Sequential Search algorithm, making this role perfect for those seeking to apply and gro...

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

...and access to themes. I am therefore not looking for theme creation from scratch in that respect. What I am looking for is graphics/illustrations and colors that I can add to my site to compliment text and help convey the page topic. Your Responsibilities: - Development of unique illustrations for website content - Creation of engaging graphics to enhance user experience - Work collaboratively on design concepts that complement the existing website aesthetics Ideal Candidate: - Open-minded in exploring diverse styles (minimalist, cartoon, realistic, etc.) - Proficient in modern design tools - Has an eye for detail and design aesthetics - Can effectively translate concepts into visual design - Prior experience in creating designs for websites ...

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

I'm in need of high-quality, informative written content for my documentation. This project demands the expertise of individuals with a solid background in producing accurate and engaging text for various types of documentation. Your main responsibility will include: - Creating informative and compelling written material - Constructing content that fits the style and tone of the documentation - Maintaining high-standard language and formatting Skills & Experience: - Exceptional skills in producing written content - Proven experience in documentation creation - Excellent command over English language - Attention to detail and commitment to quality.

I need a designer to develop an app to create frame templates for posters. - The design should be versatile and suitable for all types of festivals, including music, film, and food, with a particular focus on the festival theme. - The ideal candidate will have experience in graphic design and app development. - I'm looking for a creative individual who can adapt to different festival types and create visually appealing and engaging frames.

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 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. Need ot automate the buy/sell order 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 agree this term you will apply this task Budet is 600 INR and Good review, Dont e...

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.

...figures. Requirements: (1.) The no. of people (and total and average volumes (in EUR)) making personal investments each year in the UK (and separately in the EU) by category - stocks, bonds, crypto, on-line investment platforms (and sub-category real estate platforms - debt and equity), crowdfunding platforms, gold, REITS/real estate funds, savings accounts (banks), current accounts (banks), and "other" (2.) Numbers of households (or people if easier) earning between 50,000 and 100,000 or around those numbers." The numbers can come first - I need these urgently - charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your rol...

I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.

I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and s...

...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be...

need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

I req...presentation. This involves the incorporation of various content types in an interactive yet understandable and appealing format. The elements you're required to implement consist of text, charts and graphs, and even images and videos. Expertise in the following areas is desired: - Business presentation structuring and design - Adept at creating engaging charts and graphs - Capable of adding and modifying video content - Proficient in color scheme application and brand consistency Please note that adherence to specific color schemes and branding instructions is necessary. This specification will be provided upon project commencement. I am looking for an individual who has a keen sense of detail and creativit...

As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.