Google sheets vlookup from another sheet jobs

I'm in need of a specialized web designer to build a portfolio website for me....need of a specialized web designer to build a portfolio website for me. Here's an overview of what I'm looking for: - The website should be compact, with a structure of 1-5 pages. - A significant feature of the website should be a section dedicated to showcasing my previous works. Creativity and uniqueness would be appreciated in its presentation. - The easily accessible contact information is another key element to be included. A freelancer with a wealth of experience in designing portfolio websites would be ideal for this project. An understanding of simple, user-friendly interfaces is important. I'd also like to see previous portfolio websites you've designed. A keen eye for ...

I'm in need of a professional who can transform my existing plans into a detailed HMO layout. This task involves creating comprehensive floor plans, incorporating both provided specifications and your own recommendations. Key Responsibilities: - Translate the existing plans into an HMO layout - Suggest and incorporate furniture and fixtures - Ensure the layout is detailed and accurate - Combine provided specifications with your own recommendations Ideal Skills and Experience: - Proficient in floor plan creation - Experience in designing HMO layouts - Able to accurately interpret specifications - Good eye for detail, with a focus on accuracy - Strong communication skills, particularly in providing recommendations based on requirements

I am currently working on a project where I need to implement the flow to send and receive invoices from a DEX vending machine on iOS. To simulate the connection to a vending machine, we are using a Redpark serial cable: With this cable, I connect to a serial/USB adapter and simulate a vending machine to try sending invoices and receiving invoice adjustments in the applications. Redpark provides an SDK() and demo software for sending and receiving data, which helps in understanding the basics. However, I am currently unable to find the correct sequence to successfully send and receive invoices to a DEX machine. I understand that there is a protocol and control

I require a skilled photo editor who specializes in faces for an intricate job. The task includes: - Replacing a face with another face - I have already selected and provided the replacement. - High attention to detail in the replacement is essential, ensuring that the replaced face maintains distinctive textures, precise skin tone, and features. Ideal candidates will have substantial experience in photo retouching and color correction, ability to handle background removal with finesse, and must demonstrate proficiency in maintaining high levels of detail in their work. Portfolio showing past face replacement edits is highly desirable.

I am looking for an experienced freelancer to conduct a detailed case study on the implementation of a Zero Trust architecture in the banking sector, analyzing the economic impact of this transition.

I need a diligent freelancer to copy and paste text for me. Key Project Details: - Copy and Paste: The task involves copying text from one source and pasting it into another. - Source of Content: The text will be sourced from various online platforms. - Timeframe: I need this task completed urgently. Ideal Freelancer: - Attention to Detail: It is crucial that the text is copied accurately. - Speed: Given the urgent nature of the project, a quick turnaround is essential. Please provide your experience with similar projects and your availability.

I am looking for someone skilled in photo editing to eliminate certain individuals from my group photos. This task requires a careful and thoughtful touch to ensure that the final product looks authentic and unaffected. The People to be Removed: - Ex-partners - Ex-friends The Photos: - Group photos Ideal skills and experience include: - Advanced proficiency in photo editing software - Attention to detail - Experience with removing people from complex images - Demonstrated ability to maintain the integrity of photos after editing.

...ensuring you have the tools and resources necessary to carry out the project. - Security and confidence in the payment of your work. You will not have to fight to pay any invoice with the client. - An annual project of 38 days is to be distributed from May to December 2024. What are we looking for? Essential: - Technical and content SEO knowledge: You must have a solid technical background but also possess content development skills. Purely technical profiles without content experience are not suitable. - Presentation Skills: Competent in Google Slides or PPT and capable of delivering presentations within a framework defined by the client's global SEO strategy. - Team Collaboration: Must be skilled at working within a team, in a work environment where there will be ...

Will give u layout to design the packaging.

I'm looking for a developer who is proficient with Google Cloud Platform and PHP to set up my website. Key Requirements: - Google Cloud Platform: You should have experience with GCP, including setting up and configuring services. - PHP 5.6: You will need to work with PHP 5.6 to ensure the website's functionality. - MySQL 5.0.96: Proficiency with MySQL 5.0.96 is essential for database integration. - FTP: You should be able to set up FTP to allow for the uploading of files. - Cloudflare: You will also be responsible for making necessary configuration changes in Cloudflare. Ideal Skills: - Experience with Google Cloud Platform - Proficiency in PHP 5.6 and MySQL 5.0.96 - Knowledge of setting up FTP - Familiarity with Cloudflare configurations - Ability to ensu...

I'm seeking a developer to create a comprehensive members' social media software. This software should be responsive and functional across both web and mobile platforms. Key Functionalities: -Instant messaging: Members should be able to privately communicate with one another. -Photo and video sharing: A core function should include the sharing and commenting of multimedia content. -Blogging and forums: Members must have the ability to write posts and create threads for discussions. The platform should optimally support a user base of 1,000 to 5,000 members. Applicants should have a robust background in social media software development and be experienced in implementing the functionalities listed above. An understanding of scalability will be crucial for this project.

I need an expert to design an effective Business plan offering memorandum ...investors and aim to provide a clear understanding of our business model and financial health. Key Requirements - Business plan -Vacation rental industry not a must - Proven experience in drafting offering memorandums and business plans, preferably within the real estate sector. - Strong understanding of financial data presentation, particularly income statements, cash flow statements, and balance sheets. - Ability to design a document that is engaging and convincing to potential investors. The perfect candidate will demonstrate impeccable attention to detail, a solid understanding of the real estate and investment sector, and experience in financial document preparation. I look forward to receiving ...

I'm looking for a professional who can extract specific text content from a website and organize it into different categories.

I am looking for a Jinja2 frontend developer to convert our simple Figma design files into Jinja2 files. This wor...implement into our site. Key Responsibilities: - Translate Figma design files into Jinja2 web templates. - Ensure the templates are well-structured, clean and easy to implement. - Implement basic functionality like navigation bars, forms, and image sliders. Ideal Skills: - Proficient in Jinja2 templating language. - Strong experience in frontend development. - Familiarity with implementing designs from Figma. - Ability to work collaboratively with our in-house frontend developer. This project is straightforward as the design is simple with just a few pages. The successful freelancer will play a crucial role in setting the foundation for the implementation of our ne...

Create a Google Sheets system for managing alcohol inventory. Includes columns for Brand, Name, Number of bottles, Country, Rating. Dropdown for rating (1-10). Show stats: unique bottles, total bottles, countries. whit a front page where i can insert the above items, and get under a reading of stats.

...and within this there are some associated subcategories (Example: Pokemon), we need to add another level of subcategory (Example: Pikachu SV4 2024). The scheme would look like this (Example: Cards->Pokemon->Pikachu SV4 2024). The main category already allows the creation of subcategories, it is necessary to simply create a second level of subcategories and the client cannot publish in subcategory level 2 only in level 3. The following is necessary: 1st. Create a second subcategory level linked to another subcategory. 2nd. In that second level of subcategory, at the top there appears an image of the category, a descriptive text and a graph that shows the evolution by month and year of the price from lowest to highest. That graph will take the price data of t...

...store into the appropriate categories and collections. Additionally, I need someone who is experienced with Shopify and Google Merchant Center to fix the errors that are currently preventing my listings from going live. Key tasks include: - Organizing 15,000+ products into proper categories and collections according to a provided .doc file. - Fixing errors on Google Merchant Center to ensure existing listings go live. - Making necessary adjustments to the Shopify theme, including changes in colors and layouts, for a more appealing store design. The ideal candidate should have: - Extensive experience with Shopify store management and organization. - Proficiency in Google Merchant Center and fixing product listing errors. - A good eye for design, particularly...

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a to...

I'm looking for a PHP expert to handle several minor tasks on my website. K...expert to handle several minor tasks on my website. Key Responsibilities: - Implementing links from images to other pages. - Making the odd amend to the site - updating google maps code The work is quite straightforward and doesn't involve any major development. It's more about making small changes and ensuring the website works smoothly. Ideal Skills: - Strong PHP development skills. - Proficiency in HTML, CSS, and JavaScript. - Experience with integrating links and implementing simple changes. - Ability to understand existing code and make small tweaks. If you're a PHP developer who can quickly and efficiently manage these minor tasks, I'd love to hear from y...

I'm looking for a skilled photo editor who can remove six palm trees from an image and fill in the space to make it appear as if they were never there. The aim is to blend the background seamlessly. Retaining high detail in the remaining parts of the picture is critical. Your expertise in photo manipulation and detail-enhancement will be a great fit for this job. High-level proficiency in using photo editing tools such as Adobe Photoshop or GIMP is essential. Strong attention to detail is also key to ensuring the picture maintains its natural look. If resolution can be increased, that is a plus. Keeping the cost down is important.

I'm in need of someone to take the following designs and redraw them using photoshop or illustrator. It's a straightforward design. * Key Skills: 1. Graphic design 2. Logo design 3. Creative direction * Ideal Experience: 1. Have previously redesigned logos. 2. Experience in creating intricate logos. 3. Understanding of color psychology would be advantageous. Remember, I'm not necessarily out to recreate the wheel here, but I'm definitely looking for a more refined, sophisticated look.

I need a competent developer to incorporate bank transfer as a payment method on my existing website. Currently, my site only supports PayPal and I want to add another layer of customer convenience by allowing bank transfers. I need to be able to sell theater tickets, so an interactive sitting map should be available. While I haven’t decided yet on a specific bank or service for processing these transactions, I am open to suggestions. If you have prior experience with multiple processors, that would be a significant advantage. Ideal skills and experience: - Proven background in E-commerce website development - Knowledge of various payment processors - Understanding of safe and secure payment gateways - Ability to integrate new payment methods without disruption of site p...

We have Andorid TV app built in OS 9 chipmunkband seem to have problem working in Andorid boxes 10 and 11 but work on phone no problem and So we think we may need to upgrade gradle and some depencies Also we need package changed so the upgrade is done it will installed and not conflict with exsisting apps that are same Build .so os will see as a different app Attached are two soure codes similar

I need a simple Android app that can automatically send messages to a WhatsApp group at random times. The app should: - Allow me to adjust the number of messages sent daily - Send messages at truly random times User Interface: - A simple UI for: - Adjusting the daily message count - Customizing the message content The app does not need to inclu...WhatsApp group to take an alcohol test and post the video of the test in the WhatsApp group. The purpose is to monitor an individual with alcohol dependency to ensure they do not consume alcohol. The other members of the WhatsApp group will then review the posted video. These 3-5 prompts should appear at random times in the WhatsApp group each day. If it is too difficult to implement with WhatsApp, another messaging service could be c...

I need a professional to set up an automated workflow system using Zapier for my WordPress site. The system should: - Allow me to easily upload PDF documents for conversion - Automatically create AI optimized SEO article based on the document text - Categorize the extracted content into predefined sections - Generate a structured post on my WordPress site based on the categorized content. Ideal Skills: - Proficient in Zapier and WordPress - Experience in creating automated workflows - Knowledgeable in data extraction and categorization techniques

create a printable sheet for me. The sheet will need to be in standard A4 size (8.27 x 11.69 inches). The content of the printable sheet will be a mix of text and images, though exact details are yet to be determined. .

I am looking for a skilled professional who can take the content of my PDF book and make automations it into multiple SEO articles that will get automated post on Wordpress. These articles should be approximately 1500 words each, and should be generated automatically. Key requirements: - Understand SEO principles: The generated articles should be optimized for search engines, with appropriate keyword usage and content structures. - Automation skills: You should have experience with tools like Make or similar AI-powered software to automate the article generation process. - Attention to detail: The content should maintain the integrity of the original material, ensuring a high standard of readability and coherence. I am looking to generate several articles, so please let me know how many ...

I am looking to optimize the user experience and interface for the order page of my website. The page will feature a variety of products, each with an image, a description and an item list. Key Requirements: - Design a clean and intuitive user interface for a WordPress website - Create a coherent and engaging user experien...consisting of numerous product listings - Ensure the design is conducive to high conversion rates - With Order Button The ideal freelancer for this project should have: - A proven track record in UI/UX design, particularly for WordPress - Experience in designing e-commerce product pages - A creative approach to user experience and interface design References: - First attachment is the product details sheet. - The other attachments are other product pages tha...

My company has a logo, recently I noticed a very nice brush effect on another company's logo that I want to apply to my current one. I have the reference so it should be very quick and straight forward . thank you, the reference is attached below

We want to extract members from one Facebook group which contains about 24.000 members. We don´t know if this is possible or not. We want to create a group and invite all these members to them.

...the Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the necessary feedback will be given to the user during the payment and return processes. In addition, a simple...

Hello, I have a webpage ready designed. And a wordpress template to create the site. I need someone to put it together. And some help with finishing it. Also I need Elementer installed and cms.

I'm looking for a couple of strong individuals who can disassemble two platform beds in one room, move them to another on the same floor, and reassemble them. - **Task**: Disassemble, move, and reassemble 2 platform beds. - **Beds**: Platform beds. - **Accessibility**: No concerns, rooms are easily accessible. - **Equipment**: The beds are heavy, and the job will require at least two people. - **Timeline**: The task should be quick, but precision is key so wood doesn’t get damaged Ideal candidates for this job should have experience with furniture disassembly and reassembly, good physical strength, and timeliness in their work.

I'm in need of a professional designer to create a 24-page A5 booklet for my estate agency. I want the design to be traditional and elegant, as our target is to attract new potential clients. Key Requirements: - The booklet should be 24-pages long, a5 sized (6 a4 sheets folded in half to A5 size). - The design style should be traditional and elegant. Content: - I'm keen to include information on local property values in the booklet. This is crucial for potential clients who are interested in the real-estate market in our locality. Skills and Experience: - I expect the designer to have experience in creating similarly styled elegant and traditional designs. - A good understanding of the real-estate market or experience in designing for estate agencies would be a plus. ...

I require a capable developer to create a new Python module from Wazuh server using C programming. This module should retain the following functionalities from the original: - Agent registration - Remote configuration - Log receiving A deep understanding of TLS and SHA technologies is a must.

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

...final one is loaded. I need one font instantly loaded rather than how it appears currently. I’m happy for this to be a different font (such as one that sits on Google), if it will load instantly, however I want the font still looking good, Lead Form capture not working The form capture isn’t working correctly. Originally it was sending through to my email address when someone filled out a form, however I had my email moved from GoDaddy to Google and it hasn’t worked since. Additionally the form capture doesn’t have the capability to actually see the responses within WordPress. I am happy to change to a different form if another is more suitable and providing the cost is minimal. Free cookie consent loaded I want a cookie consent t...

I'm looking for a Google Ads specialist to help drive website traffic effectively and efficiently. Key Requirements: - Proficient in Google Ads: You should have a strong understanding of the platform's features, including keyword targeting, ad placement, and budget management. - Experience in Website Traffic Generation: You should have a proven track record of increasing website traffic through Google Ads campaigns. - Target Audience Knowledge: An understanding of the professional demographic (aged 25-40) is essential. You should be able to tailor ad content to resonate with this group. Your primary goal will be to increase website traffic amongst professionals aged 25-40. I'm looking for a professional who can effectively manage and optimize the camp...

I have a set of old drawings in IMG format that I need converted to PDF format that is acceptable to a building dept for upgrade permits. We want to add a deck in front of the garage which will be the width of the garage appx 19' x 15'. If you have experience in architectural drawing, drafting and design, and proficiency in working with PDF formats, then you're the freelancer I'm looking for. Unfortunately, I do not have specific features or elements that I want to incorporate in my deck plan. It'll be great if you can provide some suggestions on possible seating. I'm only looking for help with the drawing and end result would be something I can submit to city of San Diego building dept for a deck that I'm going to build myself.

I am looking for an expert proficient in handling Outlook PST files and cloud storage services to relocate my PST folder from OneDrive to Google Drive. - I use Microsoft Outlook for email and have been encountering storage space limitations with my current setup. - The size of the PST file is between 2GB and 10GB. - The main goal of this project is to alleviate the storage issue while ensuring a seamless transition of my email data to Google Drive. Ideal candidates should have: - Strong experience with Microsoft Outlook, including handling and migrating PST files. - Proficient knowledge of both OneDrive and Google Drive to efficiently move the PST folder. - A clear understanding of data migration best practices to ensure all data is securely transitioned w...

I need an experienced web developer who can create an e-commerce website with a professional and corporate aesthetic, targeted at a middle-aged audience. The website needs to feature embedded subscription services, via API integration, from another website ("White Label"). Key requirements: - Design, create and host a professional Subscription site. - Integrate subscription services via API from another service provider. - The website should appeal to a middle-aged demographic. Ideal skills and experiences: - Proven experience in e-commerce web development and design. - Expertise in API integrations. - A strong understanding of target markets and designing with them in mind.

...seeking a skilled freelancer to help us capture high-quality screenshots and record demonstration videos of our mobile app for both Google Play and the Apple App Store. The freelancer should have access to both Android and iOS devices to perform the tasks effectively. Requirements: Screenshots: Android: Capture 10 high-quality screenshots showcasing all key functionalities of the app. iOS: Capture 10 high-quality screenshots for each device size: iPhone 6.7" iPhone 6.5" iPhone 5.5" iPad 13" iPad 12.9" Screenshots must be taken directly from each device; resizing from other screenshots is not acceptable. Ensure all screenshots comply with the guidelines of both Google Play and the Apple App Store. Screenshots should highlight the mai...

Hello, I am looking for a Google Ads expert to assist me with the following tasks: 1. Set up Google Analytics and Google Tracking. 2. Launch and manage a single Google Ads campaign. 3. Optimize the campaign for better performance. My monthly budget for this project is $100. If you are interested and believe you can meet these requirements, please get in touch. Thank you, Azmi

I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has a firewall in place for the SQL database that requires careful ...

I need a simple Android app that can automatically send messages to a WhatsApp group at random times. The app should: - Allow me to adjust the number of messages sent daily - Send messages at truly random times User Interface: - A simple UI for: - Adjusting the daily message count - Customizing the message content The app does not need to inclu...WhatsApp group to take an alcohol test and post the video of the test in the WhatsApp group. The purpose is to monitor an individual with alcohol dependency to ensure they do not consume alcohol. The other members of the WhatsApp group will then review the posted video. These 3-5 prompts should appear at random times in the WhatsApp group each day. If it is too difficult to implement with WhatsApp, another messaging service could be c...

SEO Audit tool need to make using google lighthouse Hello, 1, We want to make an SEO audit tool, by the help of integrating the google lighthouse to generate an SEO Audit report. Here is a link to how you can do it. Here is an example how these people have integrated and using google lighthouse to generate reports. We need exactly the same. 2, need an admin panel where admin can add or import the list of the website url,and website owner name , number and email address. So report can generated by the system and keep sending the email pdf report to the owner of the website like its work in front side for this site

I'm in need of a Bulgarian resident who can assist me in obtaining a certificate of fiscal residence from the Bulgarian tax office for my company. Your role: - You don't need to be the company owner, but you should be living in Bulgaria. - I don't have the legal authorization to obtain the certificate on behalf of the company, so you should have experience in navigating this process. - The certificate will be used for tax purposes in another country Ideal Skills and Experience: - Residency in Bulgaria. - Legal expertise in obtaining documents on behalf of a company. - A good understanding of the Bulgarian tax system (optional)

Google Business Profile We are looking for a Growth Manager who can grow us with his work and help in taking your business forward.

- Moving from Iubenda to Mirasvit (I will buy and install extension) - Fixing Alpinejs and Google consent exceptions (as seen on Firefox), double check exceptions cross browser. - Check Mageplaza blog (): for example it seems that is needed by extension, I removed it because is useless in frontend, but need to be double checked.

I am in need of a Flutter-based image editing tool that can perform specific functions. The main requirements for the project are: - Development of a tool that can work seamlessly on both Android and iOS platforms. - The tool must be capable of copying a part of an image and pasting it in another location. - It should support different image formats, ensuring compatibility with various image types. The user interface for the tool is expected to be: - Interactive: The tool should engage the users and provide smooth navigation. Ideal skills for this project include proficiency with Flutter, knowledge of image editing functionalities, and experience in developing user-friendly interfaces. Successful completion of this project will require a thorough understanding of the requirement...