How to merge two excel sheets based on one column vlookup jobs

I'm on the lookout for a talented and trustworthy virtual assistant based in Lesotho to assist me for a month. It's crucial to note that I expect the assistant to be physically present in Lesotho; VPN usage is not allowed due to security reasons. Tasks: - Data Entry: You will be required to handle data entry tasks efficiently and accurately. - Social Media Management: I need assistance in managing my social media accounts, including content posting and engaging with my audience. - Account Management: You will handle various aspects of account management, which will require attention to detail and a proactive approach. Duration and Hours: - The project duration is one month. - I expect you to work less than ...

...project requires an experienced programmer who has the technical abilities to modify an XSL style sheet and adjust its layout. The task will specifically focus on: - Changing the layout of the style sheet and VB code. This modification is needed to appropriately accommodate some new fields that have been added to an import file. - Improving the style sheet so as to automatically map the new fields from the import file. The ideal candidate for this job should have experience with layout adjustments in XSL style sheets, automatic mapping of new fields and VB coding. Your skills and experience in rearranging content layout, updating fonts & colors, and altering data display formats will be highly appreciated. Don't hesitate to ...

...building project that requires an experienced structural engineer. Your primary task would be to evaluate the necessity of central RC columns in the building by checking the load distribution from the provided load calculation sheets. Key responsibilities: - Evaluate the need for central RC columns in a multi-story building - Thoroughly analyze the provided load calculation sheets for structural integrity - Provide alternative design solutions if necessary Ideal skills for this job would include: - Professional experience in structural engineering, especially for multi-story buildings - Expertise in evaluating load distribution and structural integrity - Ability to provide alternative design solutions based on your analysis Your work will gre...

I'm encountering issues converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Abil...

I need assistance in creating a specialized budgeting spreadsheet focusing on drivers license renewal costs. As someone who understands the intricacies of financial data, your task encompasses the following: - Developing a budgeting spreadsheet with an emphasis on renewal fees. - Including a feature for expense tracking and an income versus expenses comparison. - Incorporating a mechanism for budget forecasts to plan my finances better. The ideal freelancer for this task should excel in financial data management and have a comprehensive understanding of Excel or similar platforms. Previous experience in creating budget planning or financial management tools would be a significant advantage. Let's simplify my financial management together.

As the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the assignment of these components is a manual input system. Integrating a feature for capturing photos of these errors is also crucial for this project. Ideal skills and Experience: • Proficient in 3D designs • Web Development Skills • Experience with Offline Application Development Key Features: • Assign 3D Components to Errors (manual input basis) • Capture Photos of Errors • Offline Functionality

...virtual assistant to support me during typical work hours, 9am to 5pm (UTC +1). The ideal candidate will possess the following expertise: CRM MANAGEMENT: Monitor and manage follow-ups and sales activities within the CRM. Update and maintain accurate records of customer interactions and sales leads. Assist in developing strategies to improve CRM processes and efficiency. Customer Service: Respond to customer inquiries and resolve issues promptly and professionally. Maintain a high level of customer satisfaction through effective communication and problem-solving skills. Liaise with other departments to ensure customer needs are met. Email Management: Monitor and manage the CEO's email inbox, prioritizing and flagging important messages. Draft, p...

I'm in need of two captivating, text-based logos. Key Requirements: - The first logo will represent an advertising agency called AD ADDICT COMMUNICATION. This logo should be designed to be text-based, but with a creative touch. - The second logo is for an online classified ad portal known as POST YOUR This one should also be text-based and visually engaging. Specifics: - Both logos are to be in pastel shades, so the ability to work with this color palette is essential. - You won't need to incorporate an emblem or a specific symbol subtly within the text for either logo. Ideal Freelancer: - A skilled and experienced logo designer with a strong portfolio showcasing previous work, particularly in text-based l...

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Winner with real amazing design will get a nice bonus, contest prize is just so low cause I have to pick a winner right away I am looking for a skilled UI/UX designer to create a minimalist and clean interface for a new iOS application. The design will need to be optimized for both iPhone and iPad and android phones/ Key Requirements: - Prior experience designing iOS apps, particularly with a minimalist aesthetic. - A strong understanding of UI/UX principles and best practices. - Able to create designs that are visually appealing and user-friendly across different iOS devices. - Experience with prototyping tools such as Figma, Sketch, or Adobe XD would be a plus. - Availability for discussions regarding the project vision and implementation. - The design shou...

...skills to complete easy chores. Responsibilities include having regular discussions across multiple dating platforms. The final goal is to quietly shift folks from dating applications to Instagram chat or Snapchat app. This gig runs on a per commission basis and will cost $5. My virtual assistant can close an appointment in 15 minutes or less. I'd imagine. Some minor fluff discussion is required. One out of every five leads to a sale in less time. So, for now, I'll put the fee at $5. A minimum of $200 to $300 a month can be earned from your phone. only working one hour or less per day I'll be delivering two canned lines. You simply use it multiple times, but you can customize it to suit your prefere...

i am looking for one website with alomost 25-30 pages using nextjs technology as platform. the design will need to be added with tailwind css , nextjs and nodejs based Content management system where we able to manage and edit or add new contents as and when required. if anyone having ready to use cms platform for nextjs with nodejs along with good team for the web design they can provide there details of projects. the design inspiration and content inspiration will be from we will need similar design and flow as showing in this site with same contents.

I'm seeking a highly skilled digital advertising contractor to manage and drive a targeted campaign on social media and via email marketing. The successful applicant should have: - A proven track record in digital advertising, specifically in social media platforms and email marketing. - An understanding and ability to successfully target business professionals. - Tactical skills at creating and managing effective, results-driven advertising campaigns. This job is ideal for professionals who are adept at developing captivating advertising campaigns that resonate with a business-focused audience. They should also excel in consumer profiling and targeted content presentation. I look forward to hearing from you!

I'm looking for a freelancer to conduct market research to determine the best selling aftermarket products in the motorcycle industry: specifically, my target segments are in the super sport, sport, sport touring and cruiser Japanese motorcycles (Honda, Suzuki, Yamaha and Kawasaki). I'm looking for at least information from 2 databases (examples would include Amazon and Ebay but open to other possibilities too). I wanted to limit the types of products to: (1) Brackets (2) Protective engine covers (3) Levers (brake, clutch, etc..) (4) Air intake components (air intake box or air inlet ductings). The project consists of 2 parts and thinking it would be in Excel format (but open to other formats too):

I'm looking for a skilled video editor who is proficient in Canva to help me complete a 1 hour 7 minutes Canva video. 17 minutes have been created. We need to follow the same formatting / style to complete the video. We add slides (use the templates we already used) and video and some animation elements to make it look good. The voice over has been fully uploaded so the slides, video clips just need to correlate with the provided audio. Key Requirements: - Length: The final video should be 1 hour 7 minutes long. I need someone who can ensure the pacing and flow of this length is maintained. (50 minutes remaining - no modifications on existing 17 minutes) The main message of the video is to educate and inform the viewers. It is essenti...

I have a website. Need one page change dynamic from static. I have an admin panel also need control that page from admin panel. Also need a new user for admin panel with some limits. For example new user should edit only news section. Database is on postgresql.

Please Sign Up or Login to see details.

I'm looking for an expert in on-page SEO who can help me increase my website traffic. - I'm interested in SEO strategies that focus on optimizing the content and structure of my website, so that it ranks higher in search engines. - Your main goal in this project is to drive more organic traffic to my website. Your role would be to: - Conduct a detailed analysis of my website to identify areas of improvement for on-page SEO - Implement strategies that improve the website's visibility and ranking on search engines - Monitor, measure and report on the impact of these strategies on website traffic Skills and experience required: - Proven track record of successful on-page SEO projects - Strong ...

...We are currently seeking a dynamic and motivated freelance cold caller to join our team and assist in prequalifying low-income prospects for our revolutionary no-cost health benefits program. This is an excellent opportunity for individuals who are skilled in high-volume cold calling and have a passion for helping others access essential healthcare services. Responsibilities: -Make outbound cold calls to potential prospects to prequalify them for our no-cost health benefits program. -Conduct approximately 100-200 calls per day with a focus on efficiency and effectiveness. -Engage prospects in a professional and empathetic manner to gather necessary information. -Use qualifying questions to determine eligibility based on income le...

Seeking an SEP expert using Yoast Premium SEO with a good command over the English language to optimize my WordPress hosted websites. Here are the links to the websites

I am seeking an RPA Developer to automate tasks relating to a list of codes (stored in a txt file, excel file, etc) and Web interaction, for a demostration of micro RPA possibilities Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink the link will be a fixed text + the code taken from excel you will open a broswer tab with that link IF one text is present in the resulting html response, you will close the tab, and repeat the process with the next data from the file If another text is present, you will "click" 3 or 4 following buttons Iterate with the next data from the excel file Until Excel's data EOF Everything configurable via external TXT file - name of the ...

I'm in need of an experienced developer capable of creating an innovative app that will significantly impact waste management. The primary goal of this project is to optimize waste management by utilizing satellite imagery to identify dumpsites in real-time. Key Features: - Real-time Satellite Imagery: The app will need to incorporate this feature to collect the most up-to-date data. - GPS Location Tagging: Each dumpsite identified must be accurately pinpointed using GPS for easy tracking. - Dumpsite Detection Algorithm: A robust algorithm is needed to analyze the satellite images and efficiently identify dumpsites. User Base: The primary users of the app will be government agencies, so the interface must be user-friendly and intuitive. I...

...skilled software developer to help create a comprehensive property management system tailored for web-based operation. Key Functionalities: - Rent Collection: The software should have a streamlined rent collection system to facilitate regular and efficient payments. - Tenant Communication: A robust communication platform is crucial for maintaining a smooth landlord-tenant relationship. The software should include features that enable swift and secure communication. - Maintenance Tracking: A maintenance tracking system is essential for both tenants and property managers. I would like the software to have a feature that tracks and manages maintenance requests. Platform and User Role Requirements: - Platforms: The ideal candidate should be proficient in web-...

I’m hosting a contest for the recording hand gestures on video. We will be selecting multiple winners. If you are proficient with ASL (American Sign Language) this will be easy for you. $25 per approved ASL video ASL knowledge is preferred but not required. Some gestures are unique and NOT part of ASL. We have a spreadsheet with a list of gestures and an example video that you can use as a reference. The end result of the entries will be used to train a machine learning system. Requirements -recording must be .mp4 format -Gestures must be recorded in a well lighted area. -You must have a solid color shirt on... no patterns. -You must do the gestures in the order they appear in the spreadsheet -Each gesture you do, you must speak the name of the gestu...

Hey, I'm currently developing a token on Solana called Kosher Token. Once that is complete, I would like to develop an app. I would like to get a quote for developing an app with you. The app will need to run on mobile (apk) and desktop (cloud). The MVP will include two products: the Kosher Wallet and Kosher Vendor. Need a quote for each product respectively. Please see UI design attached for reference. (Desktop and mobile versions will be very similar. We do not need two completely different designs) The landing page is already done: I only need a quote for the app. Please review the documents attached and ask any relevant questions you may have. Then please send me a rough estimate and timeline. I ignore all auto bids. I only engag...

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

Hello there, We will translate your Excel file (Magic Jackpot Ads (Slots)) into Hungarian. Thank you!

Basically we are dealers in computers and cctv cameras I am looking for a website, only one messaging bar center of website once client sent message from that message, the same I have to receive on my whatsapp message and then we can continue chat in whatsapp only, basiclly I want my clients to forward to whatsapp chat and a nice bakcground image of all computers parts and cctv parts image One logo of my company name with images of computers brand

I'm looking for a skilled developer to create a smartphone application that will serve as a tour guide for travel groups. Key Features: - It should be compatible with both iOS and Android devices. - The primary feature should be the ability for a tour guide to speak to the clients in real-time, providing live, interactive commentary throughout the tour. - The app should support live chat for clients to ask questions to the tour guide. - Smartphone-based tour guide system: One simple app for both speaker and listeners. Works on any device that is connected to the internet via WIFI or mobile data like 3G, 4G or 5G. Ideal Candidate: - Proficient with app development for both iOS and Android. - Experienced in integrating re...

I'm looking for a freelancer who can create a comprehensive, user-friendly Google Form and Excel template system. This system will be geared towards the hotel management sector and will be used for recording bookings, sales, expenses, and other business-related data. Key Requirements: - Design and Implementation of Google Form: The form should be intuitive and easy to use. It should have fields for recording bookings, sales, expenses, and other relevant business information. - Excel Templates: The gathered data from the form should be integrated into a set of Excel templates. These templates should be professionally designed and easy for hotel management to use. Your Role: - Your role will be to create a system that can manage multiple busin...

I'm in need of an experienced graphic designer to create a captivating, illustrative logo that stands out and reflects the essence of my brand. This design is crucial for my upcoming product launch, and I'm working on a tight deadline. **Ideal Skills and Experience:** - Strong portfolio in illustrative logo design - Ability to translate concepts into visual designs - Proficiency in Adobe Illustrator and Photoshop - Great communication skills and ability to work under tight deadlines **Requirements:** - Design a unique, illustrative logo that embodies my brand's values and essence. - The final logo must be scalable, as its primary use has not been defined yet; it could range from web applications to print materials or product packaging. - ...

...search of a competent female operations support assistant to aid me in daily tasks. Key Responsibilities: - Spreadsheet Management: You will be tasked with keeping our Excel sheets organized and updated to ensure seamless operations. - Report Generation: You will also be responsible for generating reports for our activities. These reports must be clear, concise, and error-free. - Daily Calls: You will make regular teams calls within the operations team. - Research & Analysis: The role will also require you to conduct research and analysis on various topics as needed. Your Excel Skills: I need a candidate who is proficient in Excel. An intermediate level of understanding and experience in Excel is a requirement for th...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

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

...specifically on portrait work, even in scenarios with messy hair. The final goal is to invert the mask to be able to work on the background. I would love to have a visual representation of the Photoshop panels included. Here are some of the specific requirements: - Techniques and tools should focus on Quick Selection tool, Refine Edge tool, and Refine Hair - Each step of the process must be clearly explained. Step-by-step written instructions with supportive visuals preferred. - All information must be concisely formed into a PDF document to be both user-friendly and convenient Freelancers with advanced proficiency in Photoshop, excellent tutorial formation, and instructional design are highly valued. Previous experience in crea...

...list of 10,000 names and email addresses in a Google Sheets document. Your job will be to: 1) verify these contacts by checking if they are still active on LinkedIn, and if so, 2) determine where they are currently employed. 3) Do a test email and verify if the email address is currently active 4) Replace an inactive email with a new active email address Key Requirements: - Experience with LinkedIn verification - Strong organizational skills to handle 10,000 contacts - Expertise in using Google Sheets - Ability to cross-check large volumes of data swiftly - Attention to detail to ensure accuracy Deliverables: - A revised Google Sheets document with active contacts' current employers listed Timeframe: - I'm look...

More details: Which version of Excel are you using? Excel 2016 What type of data processing do you need? Data sorting, Data filtering What specific criteria will you use for sorting the data? Numerical order It is required to set up a script that will process an Excel file every day, filter the file according to an algorithm and leave the necessary data in the file.

...company is seeking to expand its market by targeting hospital gift shops and independent pharmacies across North America. We are seeking a consultant to generate a comprehensive list of potential leads. This list will be used primarily for email and calling campaigns to promote and sell Nurse Yard's compression socks. Target Details: Independent Pharmacies 1. Type of Pharmacies: • Privately owned pharmacies that operate independently. • Small chains or groups of pharmacies under a single ownership. 2. Location Criteria: • Urban and suburban areas with high foot traffic. • Pharmacies located near medical centers or hospitals. 3. Service Offerings: • Pharmacies that provide a range of medical supplies, over-the-counter medications, and h...

I am in need of a talented filmmaker to create a music film clip that captures energy and performance. The clip should focus on a tangible musical performance, rather than a narrative or abstract concept. The ideal candidate will have: - Experience in film clip creation, particularly in performance-based scenarios - A strong grasp of pacing, rhythm, and visual dynamics to convey energy - Innovative ideas on camera techniques to capture the best of performance This project does not require a storyline, instead focus on capturing the essence of the performance in an energetic and vibrant context. Your creative input will be valued. The successful bid will demonstrate an understanding of these requirements and showcase a portfolio or examples ...

...Data Engineer to join our dynamic team on a full-time or part-time basis. This role offers remote flexibility, allowing you to leverage your talent, skills, and extensive experience to drive our growth and surpass current limitations. The ideal candidate will thrive in a collaborative environment, inspire innovation, and demonstrate a self-motivated attitude toward excellence. Why Join Us: Joining our team presents an exciting opportunity to advance your career in the IT industry amid the remarkable growth of the US job market. As part of our prominent company, you'll contribute to cutting-edge projects that shape the future, positioning yourself at the forefront of innovation. With comprehensive support programs, we ensure a seamless tran...

I'm in urgent need of an expert in revenue summary analysis for my accounts assignment, to be completed ASAP. Areas of focus include: - Deciphering and analyzing an Excel file, which contains base financial data. - Providing a thorough understanding of the balance sheets, income statements, and cash flow statements in relation to the given data. Ideal qualifications: - Strong accounting background. - Proficiency in financial analysis and interpretation. - Familiarity with balance sheets, income statements, and cash flow statements. - Proficient in Excel data manipulation and interpretation. - Must be able to work fast as this task has a high-priority deadline.

I need a proficient Excel expert who can create an organized spreadsheet to track our monthly sales data. Key Requirements: - The spreadsheet should be organized by month. This means that the sales data for each month should be clearly separated. - The primary function required is to sum up the sales totals for each month. This will help us in tracking our sales performance over time. Ideal Skills/Experience: - Proficiency in Excel, with a good understanding of formulas and functions. - Prior experience in creating sales data spreadsheets would be a plus. - Attention to detail is crucial to ensure the data is accurately presented and calculated. Deliverables: - An error-free, well-organized spreadsheet that clearly presents our sales data o...

I need a hand with entering a small amount of text and numbers data into a spreadsheet. Key Requirements: - The task involves a small amount of both text and numbers data entry. - The specific software to be used has not been specified by me, so you can work with what you're most comfortable with. Ideal Freelancer: - Proficient in data entry, with experience handling similar tasks. - Familiarity with popular data entry software, like Microsoft Excel and Google Sheets would be beneficial.

I need help with data entry. The task involves typing data from online sources into an Excel spreadsheet. Key Requirements: - Data Entry: The primary task is to accurately enter data from online sources into Excel. Prior experience in data entry is preferred. - Typing Skills: A good typing speed and accuracy are necessary for this task. - Familiarity with Excel: Basic knowledge of Excel is required to ensure the data is entered appropriately into the spreadsheet. - Attention to Detail: The data must be entered without errors or omissions, so attention to detail is crucial. The final deliverable should be an Excel spreadsheet with the data inputted neatly and accurately.

...reliable, and trustworthy online worker. I helped many startups, entrepreneurs, and business owners achieve their business goals in the past. I am an excellent communicator with sublime linguistic skills, and attention to detail is my key skill. Ill follow your instruction for the letter and get back to you with fantastic results. Here are the services I offer: Data Entry Data Mining Excel Data Entry CRM Data Entry Data Scraping Copy Paste Work Data Conversion Shopify Product Listing WordPress Data Entry PDF to Excel or Word JPEG to Excel or Word Typing in Excel or Word E-commerce Products Listing Web Research and Web Scraping Please read the reviews from my previous clients where they speak about my professio...

I'm seeking a talented developer to build a comprehensive daily business view report integrating with Google Ads and Shopify. Key points should feature: • The report should primarily display the data in chart format. This will facilitate easy interpretation of the key points. • Core areas extracted from Google Ads and Shopify will include sales data and advertising performance, turning these into actionable insights. • The output should link seamlessly with Google Sheets and update daily allowing for real-time performance tracking. Ideal freelancer should have prior experience in similar projects, and be adept with API integrations and chart generation. Strong data visualization skills coupled with knowledge in Google Ads and Shopify are also essential.

...materials. Currently, we're managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interfaces for easy data input and retrieval - Experience working with Excel an...

I am in need of a talented artist who can take several family photos and merge them into one impactful, sentimental drawing. Please find the requirements below: - Create a coloured pencil sketch capturing the emotion of the main characters: myself, my wife, our newborn son, and our fathers. - The primary focus should be on us with some background elements included. -Can you please make the background Australian grassed bushland themed. - Depict us with a realistic (ish) style adhering to the real-life characteristics of every individual. - The image will be of my wife and newborn son in the foreground, with our deceased fathers standing over us in the background both wearing cowboy hats, maybe watching us and having a beer. The ideal candidate will have strong...

I'm looking for a Virtual Assistant to grab leads, I’ll send material on how. It’s pretty simple. We'll specifically be targeting those who work in the nightlife industry and going down the research rabbit hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Fast - Critical Thinker - Proficiency in using Instagram for business re...