Vlookup column index number cell reference jobs

...seeking an adept professional to develop a cross-platform app for real estate. Available on iOS, Android, and Web, the app's functionalities must include: - Property Search: An intuitive, user-friendly interface for users to search properties. - Filter options: Users can filter search results based on different criteria. - Saved favorites: Users can bookmark their preferred properties for future reference. The app should also facilitate user interaction with features allowing: - User registration/login: Smooth user registration and login process. - Agent registration/login: Smooth Agent registration and login process. - Property listing details: Detailed information showcased for each property listing on Map. - Contact agent/owner: Messaging feature facilitates communica...

...calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automatic calculation of the total payment owed to each installer based on the number of jobs completed. 3. **Customer Information:** - Columns for customer name, address, and account number. 4. **Summary:** - A summary section that provides totals for jobs completed and payments...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...

Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501

I need 3 custom-sized coupon designs created. I'll provide you with the specific dimensions. The job is straightforward. I have reference images for the kind of design I'm after. Your task will be to create 3 unique designs based on these references. I'll provide you with the specific dimensions for the coupons, so you won't have to guess the size. Requirements: - Experience in graphic design, particularly in creating coupons - Proficiency in design software - Ability to deliver within 1 hour If you're interested, please share some examples of your previous work in design. This will help me get a sense of your style and experience.

I need a proficient Xactimate expert to generate detailed and professional-looking reports for insurance claims. Key Requirements: - You should have a solid understanding of Xactimate software and experience in creating reports for insurance purposes. - The reports need to be detailed, with itemized costs and descriptions. The ability to include diagrams a...and photos would be highly beneficial. - You will be provided with the necessary information through document and photo uploads, so make sure you can work with these formats. Please note that the quality and accuracy of the reports are crucial, so attention to detail is a must. The ideal candidate should be able to efficiently create a comprehensive report, making it easy to understand and reference for the insurance claim...

I am looking for a professional who can build a web application that automates the creation of Google Sheets formulas. Requirements: - Build a web application that allows me to input a plain text command in a Google Sheets cell (i.e., I type "= find the mean of the data above". - Translate the plain text command into a Google Sheets formula using the ChatGPT API. - Authenticate and send the formula to Google Sheets for execution. Ideal candidate: - Proficient in web application development. - Experience with integrating APIs, particularly ChatGPT. - Familiarity with Google Sheets automation and formula creation. - Strong understanding of user interface design for a seamless user experience.

1) You will help me reach out to recruiters, hiring managers and talent acquistions regarding particular positions 1a) Share the actual job applied to in the spreadsheet so i can reference it if I get contacted.***very important*** 2) Help manage applications 3) Filter job search and apply- (will share details when we speak and if hired) 4) More details will be shared in messaging and a call we will have weekly 5) weekly checkins 6) set up interviews for me via my Calendly 2hr max

... -OSCOLA style should be used. -The size of the assignment must not exceed 3000 words excluding footnotes and bibliography. -Must be submitted in word format only. -Must be saved in your student ID number. Guidance A)Students need to observe the following points in drafting their assignments introduction progression of ideas transition throughout essay leading to a well-developed argument of analysis quantity of research demonstrated conclusion of references provided at the end of the assignment. use of reference style use of quotes to support the argument count B)Writing instructions: : •This should, inter alia, provide a brief about all the issues you wish to discuss in the

...and realistic 3D model. This will help me understand how the final space will look. - Client Presentation: The rendering should be of a quality that I can use it to present my design to clients. It should be professional, detailed, and showcase the key elements of the design concept. - Interior design rendering with pictures of the floors in the shape of a running track, numbered with the track number and the distance traveled on both sides of the escalators, as well as in the floor areas that do not have escalators, showing the percentage of calories burned for each specific distance, and pictures on the walls of information about health, nutrition, and others related to the health facilities of the facility itself. Also, in the middle of the bridge, in the corners, there are gi...

...who can assist me with various design tasks including graphic design, content creation, and reference design. Key Responsibilities: - Branding Materials: The core requirement is to design a captivating post graphic that aligns with my brand's visual identity and messaging. This will need to be compelling, eye-catching, and consistent with the brand's overall tone. - Content Creation: I'm looking for a content creator who can help me craft engaging and relevant content for my brand. The ideal candidate will be able to produce content that resonates with my target audience and effectively communicates the brand's values and offerings. - Reference Design: You will also be responsible for creating reference designs that can be used for future projec...

I'm in need of a 2 to 3 page paper on the subject of continuous improvement specifically focusing on Lean management. It will be submitted as an academic assignment so...on the subject of continuous improvement specifically focusing on Lean management. It will be submitted as an academic assignment so it should be well-researched and articulate. Key aspects of the work include: - Research and write a clear and concise paper on the topic of continuous improvement - Focus on Lean management as the primary methodology - Accurate referencing and inclusion of a reference list Ideal skills and experience: - Strong understanding of Lean management principles - Academic writing experience - Ability to research and synthesize information accurately - Proficiency in citation and ref...

I'm in need of a developer who can create a web-based lottery system for me. The system should be designed to allow anonymous participation,...selection: The system needs to be able to select winners automatically without manual intervention. Ideal Skills and Experience: - Proficiency in web development - Experience in creating lottery systems or similar - Knowledge of automated selection processes This project involves a good amount of logic and system design, so experience in similar projects is highly valued. Your bid should include a reference to your previous work and a proposed timeline for completion. Please get in touch if you're confident in delivering a reliable, scalable, and user-friendly lottery system. PHP an Laravel based system, with admin panel, referal...

I am seeking a skilled designer for a furniture project involving the creation of modern chairs and tables. Key Requirements: - Extensive experience in furniture design. - Proven track record in designing modern style furniture. - Proficiency in working with metal as the primary material. - Ability to share previous project samples as reference. Ideal Skills: - Sound knowledge of the latest trends in furniture design. - Excellent understanding of modern design principles. - Strong experience in working with metal. This is an incredible opportunity for furniture designers interested in modern design and metal work. Please share portfolios or examples of previous work that align closely with the requirements mentioned above.

I have an excel file, need add product categorie on a column - budget 100€

I need a Blazor application, like a teleprompter, that allows users to control the scrolling of text by reading out loud the text. When the user stops reading, the scrolling stops. When the user starts reading again, the text should resume scrolling. It should be specifically designed for web browsers, being compatible with...application should be responsive, efficient, and user-friendly. The successful freelancer should have experience with: - Blazor application development (WebAssembly). - Voice recognition technology - Web compatibility and optimization If you have worked on similar projects, please include details in your proposal. Required Delivery: Visual Studio 2022 solution Blazor WebAssembly Web application Reference:

I'm in need of an experienced professional who can rig my 3D models and adjust some details in need (like texture, number of triangles...) for a game called Zepeto. The price will be 4$ for each model (price is negotiable). Key requirements include: - Expertise in rigging 3D models using Blender If you have a deep understanding of these areas, I'd be happy to discuss the project further with you.

We need logo for our fitness product brand "Styfit" which is a fitness brand, which we are going to lanuch in our e-commerce store I have attached a sample logo for your reference. Need source file with all the fonts and elements. if you have any questions, please dm me. Thank you!

I need a solution that can automatically insert page numbers onto every A4 page in my document at the bottom. Key Requirements: - The system should work with A4 format. - It should be able to insert these page numbers automatically and consistently on every page. - The page numbers should be placed at the bottom of each page. Ideal Freelancer: - Experience working with PDF manipulation and automation. - Proficient in software that can perform automatic page numbering. - Attention to detail in maintaining consistency in design and positioning of the page numbers.

...picture, no stock photos, only unique pictures and contents. We, as a company will help create a lot of these, it's about creating and establishing a great communication flow to archive high-end results, and there are many apps for that. This is a fulltime position for a person with many years of experience landing companies on the "first page". GBP is way more important as a tool than being ranked number one on a laptop, less prospects are using stationary computers by the day, it's plus 85% hand-held devices. You will be given recourses and other team members to work with, but you will be in charge of what needs to be done, how and when. You will be compensated monthly/ hourly. You will also get bonuses for certain milestones. The owner is also willing to ...

I'm seeking a skilled freelancer to help me standardize and improve the formatting of my Google Sheet. The main focus will be on creating consistent cell styles for optimal readability. Specific requirements include: - Implementing a minimalist and clean design theme throughout the sheet - Creating a uniform style for all cells, making sure the data is easy to understand at a glance The ideal candidate will have: - Proficiency in Google Sheets, with a strong understanding of formatting options and best practices - A keen eye for design and the ability to create a clean, minimalist look - Experience with data visualization and turning complex information into easily digestible formats If you're confident in your ability to transform a spreadsheet into a visually appeal...

Storyboard of Rafiki (as discussed text but adding some reference sketch images too)

...Google Mediapipe Pose Detection and has run trained ML models on web application (using JavaScript) The main task will be training the model to recognising the pose and creating a script for data generation from youtube videos. The trained model should work with the web mediapipe library and classify the given pose on a WebApp (JavaScript). (Eg: Push up and Push Down) You can refer this blog for reference: This project requires expertise in machine learning algorithms and techniques, as well as experience with Google Mediapipe and data preprocessing. The successful candidate should have a strong understanding of supervised learning and be able to optimize the model for accurate pose classification using JavaScript. The

I've compiled a comprehensive global leads database with 8 million entries. The database includes a variety of details such as name, email, contact number, website, profession, and even Instagram username. - **Purpose**: This database is specifically designed for sales leads generation. It's meant to help businesses and organizations reach out to potential customers and grow their sales. - **Categorization**: The leads are not just categorized by one specific filter. Instead, they're a mix of different categories from various industries, countries, and professions. This eclectic mix provides a wide range of opportunities for potential buyers. - **Delivery Method**: I'm looking to sell this database through a CSV file, online access to the database, and a Goog...

My goal is to have a complete informational website developed for my business. With a focus on offering key details like: - About Us: A section devoted to explaining our business and its values - Services: A clear and comprehensive listing of all our services - Contact Information: Clear details on how customers can contact us; including phone number, email address, and physical location - Pricing: Transparent pricing information for our services The ideal freelancer for this project should have prior experience in developing informational websites with an easy to navigate user interface. Proficiency in web design and development and a keen eye for detail is necessary. Knowledge of SEO to help maximize the visibility of the website on search engines is also appreciated. Be pre...

I'm seeking a WHMCS module that facilitates direct connection between my .in domain registry and WHMCS. It's built on the Neustar toolkit for registrars. For reference, I've included a link to an existing module developed by another party: I'm looking for a similar module without licensing restrictions and at a more affordable rate than the one listed.

...position with flexible hours. Responsibilities: Source and attract candidates using databases, social media, and other recruitment platforms. Conduct interviews and filter candidates for open positions. Collaborate with hiring managers to understand job requirements and candidate profiles. Create and post job descriptions on relevant job boards. Screen resumes and job applications. Perform reference checks as needed. Provide a positive candidate experience throughout the hiring process. Requirements: Proven work experience as an HR Recruiter or similar role, preferably within the BPO industry. Familiarity with Applicant Tracking Systems (ATS) and resume databases. Strong knowledge of sourcing techniques, including social media and professional networks. Excellent communication...

HI we are looking for Web and mobile app developers for cs cart who can also give some idea. ( using ) Reference is We will add Auction bidding option ( ) I was hoping to see any references you’ve created that is similar to direct-liquidation idea, we want something very similar but with having the auction feature added, which is something already available and offered from CS-Cart Looking to see what would you suggest to make with a similar idea to our reference Buy now and Bid option with payment gateway. multivendor with a bidding system. Ppl can buy or bid based on vendors choice and the system

I am seeking help with APA 7th edition format for an academic paper. This includes in-text citations, reference list formatting, and title page formatting. The specific requirements for this project are: - Formatting in-text citations according to APA 7th edition guidelines. - Ensuring the reference list is accurately formatted and adheres to APA 7th edition standards. - Formatting the title page according to APA 7th edition guidelines. The ideal candidate for this job would have: - Proficiency in APA 7th edition format. - Strong attention to detail. - Experience in academic editing. The paper is VERY SMALL (less than 2000 words).

I'm in need of a skilled professional to help with a Spanish voice-over project. I'm looking for an individual who is able to fluently spea...Spanish language itself. Given the nature of the project, it would be preferable if the individual has experience in the following areas: - Voice-over work, specifically in Spanish - Previous experience in radio or podcasting - A background in linguistics or teaching Spanish would also be beneficial. There is a possibility that the project may require more than a few recordings. The exact number is not yet determined, but it would fall into the range of less than 10 to more than 20. I'm looking for someone who is not only a skilled language speaker, but also has a professional attitude towards their work and can deliver...

I'm in need of someone who is experienced in graphic design to convert and edit a series of JPEG logos into a vector format. Here's an overview of what I need: **Conversion to Vector Format**: I need the logos to be transferred into a vector format wit...format without any background. This is important for their use in digital media, so it's crucial that the final output is of high quality and resolution. **Grayscale Edits**: The vectorized logos should be in grayscale, mirroring the specific range of the bottom banner. This means the freelancer will need to match the grayscale of the bottom banner, ensuring a consistent look across all logos. REFERENCE: SAME BOTTOM BANNER AS Have attached the logos along with this posting

I need someone to edit photos in lightroom or photoshop. Somewhere at 300-400 pictures, the payment will vary depending on the number of pictures. Color adjustment, small edits and a good preset. We will make a sample of a few pictures, before starting the collaboration.

The objective is to develop an application to manage two devices via WiFi (may be increased in the future) I have two devices: Sauna and red light therapy panel. They all have a touch control panel and can be connected to your cell phone via Bluetooth and Wi-Fi. Many of the providers also offer you the mobile application already developed (as can be seen in the attached images). The idea is to make a similar application from which the two devices can be managed (set time, lighting, power, etc.). And the history of uses/settings is saved. It could also be evaluated to take the code of the two suppliers' applications and combine them into one, strongly separating them within it.

I am looking for a videographer to film a fitness competition, HYROX Gdańsk, on 26th of May. They’re finalized video should be shorter than 10 minutes. Please have a look at this reference video (starting 8:10) Key Responsibilities: - Capturing high-quality videos of the whole sporting event. - Professional post-event editing. - Adding effective after effects to ensure the final video is engaging and thrilling. Ideal Skills and Experience: - Previous experience in filming and editing sporting events. - Excellent knowledge of different video editing software and aftereffects tools. - Innovative and creative with a proven ability to deliver quality content. - Great attention to detail and sensitivity to the atmosphere and dynamics of a sports

I am seeking an expert to develop a comprehensive marketing plan through Google Ads, Facebook and LinkedIn ads for a home loan aggregation company. The primary goal is to generate customer leads and Direct selling Agent leads in Hyderabad, Delhi, and Mumbai. Key Tasks: - Keyword research: Identify and suggest relevant k...Ideal Skills and Experience: - Extensive experience in Google Ads, Facebook and LinkedIn for lead generation. - A strong understanding of the Indian market and its nuances, particularly in Hyderabad, Delhi, and Mumbai. - Proven track record of delivering successful online marketing campaigns. - Excellent communication skills and the ability to translate complex data into actionable insights. Reference sites -

i have a list of 11,000 car part numbers. need to find the image from each one, if you type the part number in google you'll find the image for that part.

...task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential for automation: I'm not entirely sure if I want the macro to automaticall...

I am in need of someone who can help me gather email addresses, websites, and phone numbers from the links in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be coll... use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email addresses, websites, and phone numbe. 4. To manually check the result and collect Website name, Email address and phone number. if there are more than one email address please include ...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm looking for a talented designer who can create a modern and minimalist logo to represent my security company APH Commissioning. The company works with ACCESS CONTROL, CCTV AND INTRUDER ALARMS! Key Requirements: - The primary goal is to establish a strong brand identity through the logo. It should be memorable and easily recognisable. - Potentially reference CCTV, ACCESS CONTROL OR INTRUDER ALARMS. - I'm open to suggestions regarding the color scheme. Feel free to propose a palette that you believe suits the modern and minimalist style. Ideal Skills: - Proven experience in logo design, especially in creating logos that emphasize brand identity. - A strong portfolio showcasing modern and minimalist design aesthetics. - Excellent understanding of color psychology in de...

Please Sign Up or Login to see details.

I'm looking to create a binding within Openhab for an Elmo alarm system. The binding needs to enable the following functionalities: - Remote arming and disarming of the alarm system. - Monitoring the status of individual sensors and zones. - Sending sensor states to OpenHAB items. I do have a similar project that was written in Python for Home Assistant which I can provide as reference and guidance. Ideal Skills: - Strong experience with Openhab binding. - Proficiency in Python programming. - Familiarity with the Elmo alarm system will be a plus.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...exclusion criteria and providing a document containing the output. The details of the literature search can be found in the following link. The candidate performing the job should be skilled in performing medical literature database searches, able to collate the results and write an academic document containing citations style of Vancouver Style. There is no restriction on the number of words. Requirements: - Conduct a thorough search on PubMed focusing on Medical Informatics - Provide a detailed summary of abstracts found in the search - Ensure the search is comprehensive and up-to-date Ideal Skills: - Proficiency in using PubMed - Knowledge and understanding of Medical Informatics - Ability to summarize and report on the search results Please ensure that you have experience

I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on the image.

I need to design a new version that is better than my reference and has the same style Logo usage guidelines ,Color palette,Typography guidelines,Iconography

I need a skilled photographer to take a large number of high-quality images of industrial parts at specific location(s). Requirements: - Expertise in product photography, particularly with industrial parts. - Ability to shoot more than 50 photos. - Flexibility to work on-site at various locations. - Proficiency in lighting and composition. - Prior experience in studio or on-site product photography. Please provide a portfolio showcasing your past relevant work when applying.

Please Sign Up or Login to see details.

Beginner level freealancer to create an m...don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and sha...

...for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell. The excel file has 5 columns: 1st columns is for Brand 2nd column is for Model 3rd column is for Color 4th column is for Price 5th colums is for Quantity in Stock We want to realize a simple php page with a form to send an email with the chosen products. We need that someone just fill the database wkth the data we have in excel file (about 350 lines) To access the page we need a login page. We need 2 levels: 1 level: administrator 2nd level: agents One...