Google sheets vlookup from another tab jobs

...would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integration • Laying out elegant formatting of the sheet • JSON data access library (including CRUD, parse/stream, search etc etc) • “Areas” library to create formated spaces within Excel Sheets (formating, inserting buttons, Create/Delete/InsertRows, elegant location naming systems) • Execute/Recalc tools (e.g. when the sheet is not busy it may ping a URL every 60 seconds) • Please show any experience and work done in the above We are a startup who would like to make a significant contribution to the Excel Application spa...

I am engrossed in studying a company's customer, product, and trucks data for my PhD research. Contemporary businesses encounter a significant challenge wherein their delivery trucks often travel from one region to another with insufficient loads (Half of the trucks are empty), resulting in inefficient use of resources. My research aims to minimize the number of empty or partially filled trucks traveling to those areas, particularly in the last-mile delivery process. Below is a list of stores. I kindly request you to extract the dataset from one of the listed companies. The list of stores is prioritized in order. 1- IKEA (IKEA store that located in Saudi Arabia) 2- Home Centre 3- Home Box

I am in need of a skilled individual to help me with a Google ads campaign for my sports memorabilia business. The focus of the project is: - **Location:** The initial focus will be on the Melbourne market, so I need someone who understands this market and can tailor the campaigns accordingly. - **Goal:** The primary aim of the campaign will be to generate leads. I want to attract potential customers interested in sports memorabilia. - **Services:** Although I offer custom framing and fundraising services as well, the campaign will mainly revolve around sports memorabilia sales. Ideal candidates for this project should have: - **Google Ads Expertise:** Demonstrable experience in running successful Google Ads campaigns is crucial. - **Local Market Knowledge:** A ...

We have a B2B WordPress website that fails Core Web Vitals on mobile and desktop. The site was originally made by one developer, then worked on by another, resulting in many issues due to lack of communication. The website uses Elementor and a customized theme. We would like to work with an expert WordPress developer to improve the site's performance and get it into the green in Core Web Vitals. We also want to remove all unnecessary plugins (currently the site has almost 50 WordPress plugins). We are open to moving the site to a new server if required and rebuilding it to improve performance. Looking to work with an experienced WP developer and performance expert to solve this. Please get in touch if this is something you specialize in and we can discuss this project further...

There is a website that I do not have access to the hosting and I just need an embedded video extracted from it and saved as an MP4 file. Let me know if this is something you can do, looking to get it done now within the hour.

Seeking a Google Playstore account for instant entertainment and games app deployment, with a focus on teenagers. In brief: - I aim to bypass the testing process prevalent in the usual account creation. - The focus of my app portfolio will be on applications that cater to the teenage demographic. Ideal Freelancer: - Experience with Google Playstore account transactions. - Proficiency in developing and publishing entertainment and games apps. - Understanding of the teenage market and its preferences.

My main objective is to drive product sales through a focused Google ad campaign. I need a freelancer that can: - Understand the beauty industry and the dynamics of promoting online courses. - Harness this understanding to create a strategic Google ad campaign, aimed at intermediate learners. The campaign should stand out visually but also contain content that speaks directly to intermediate learners looking to improve their beauty expertise. Experience in the beauty industry is desirable, but more importantly, I'm looking for someone who can demonstrate a solid track record in managing successful Google ad campaigns tailored to specific audiences. Familiarity with online education platforms is a plus.

I am engrossed in studying a company's customer, product, and trucks data for my PhD research. Contemporary businesses encounter a significant challenge wherein their delivery trucks often travel from one region to another with insufficient loads (Half of the trucks are empty), resulting in inefficient use of resources. My research aims to minimize the number of empty or partially filled trucks traveling to those areas, particularly in the last-mile delivery process. Below is a list of stores. I kindly request you to extract the dataset from one of the listed companies. The list of stores is prioritized in order. 1- IKEA (IKEA store that located in Saudi Arabia) 2- Home Centre 3- Home Box

I need financial data from bloomberg or any other database for research.

I'm looking for a skilled professional who can help me generate leads with a new Google Ads campaign in Saudi Arabia. Ideal Skills and Experience: - Proficiency in Arabic language is a must - Extensive experience in Google Ads, particularly in lead generation - Familiarity with the Saudi Arabian market and audience preferences Key Objectives: - Tailoring the existing Google Ads campaign to target the right audience in Saudi Arabia - Ensuring the ad effectively generates leads for my web design and development business - Incorporating a clear call-to-action for people to reach out via WhatsApp or phone call after clicking on the ad Please include "I know Arabic" in your bid to indicate you've understood the requirements.

Hello Christian, Thank you for discussing the interior design project for your living room. Considering the floor plans, photos, and moldboard design you've shared, I propose delivering approximately 8 realistic rendering images within 7-10 days for 700 EUR. The payment will be divided into two milestones: one for the preview and another for the final rendering images. Best regards, Mohsen

I'm in the process of designing an e-commerce website in Figma and I'm seeking a frontend developer who can transform this design into a fully functio...mind for this project: - PayPal: A widely used payment gateway that provides flexibility in payment options and offers a trusted payment experience. - Stripe: Another popular choice for online transactions, Stripe offers seamless integration and a secure payment process. Ideal Skills and Experience: - Proficiency in frontend development - Experience with e-commerce website development - Knowledge of Figma or similar design tools - Experience in integrating payment gateways, especially PayPal and Stripe If you're confident in your ability to bring this Figma design to life and create a smooth e-commerce experience, I...

...expert who is Google Ads Certified and able to verify crucial business operations, particularly related to my advertising campaigns. The focus of this project is to ensure the complete and accurate functioning of my PPC campaigns. This involves the following key aspects: - **Business Operations Verification:** The ideal candidate will have a deep understanding of Google Ads and be able to perform a comprehensive verification of the business operations linked to my PPC campaigns. This includes ensuring that all tracking and conversion mechanisms are set up correctly and functioning optimally. - **Google Ads Certification:** It is crucial that the chosen freelancer is Google Ads Certified, as this certification signifies a high level of expertise and knowle...

...designer who can create a memorable, professional, and visually appealing logo for a Trucking Transport Company. The logo should draw the attention of my target audience and help establish a strong brand recognition. Key Requirements: - The Name R.T.J. should be inserted on the grill - The word TRANSPORT should be put on the front bumper bar, both carved in one example and straighter cross in another example. - the logo should convey an icon of the front of a truck (see attachment) with the name inside sections. - The logo should be created with some blues, some gold font colours - the logo should be given to me in a few different colour samples I'm on a tight deadline for this project and need it to be completed as soon as possible. Ideal Skills and Experience: - Prov...

I'm in need of a Google search expert to help with keyword research and ad campaign management. Key Tasks: - Keyword Research: The primary goal of this research is to increase website traffic. The expert should be able to identify high-performing keywords for our industry. - Ad Campaign Management: The target audience for these campaigns are national customers. The expert should be able to set up and manage effective campaigns on Google. Ideal Skills and Experience: - Proven experience in keyword research and search engine optimization. - Track record of successful ad campaign management, particularly for national audiences. - Knowledge of Google's advertising platform and its functionalities. - Ability to analyze data and optimize campaigns for better performanc...

*PLEASE READ THE GOOGLE DOCK BELOW CAREFULLY AND CONTACT US FIRST IF YOU HAVE QUESTIONS* Details of our current project STACK can be seen here -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we

I'm seeking a developer who can help me resolve an issue that the google pay button doesn't appear when the allowed auth method is CRYPTOGRAM_3DS. Thank you,

I'm seeking a developer who can help me resolve an issue that the google pay button doesn't appear when the allowed auth method is CRYPTOGRAM_3DS. Thank you,

...profile visibility settings. -Improve the registration process with email verification and social login options. -Enhance image management, including cropping, individual image uploads, and modal development. -Upgrade the "Blocked users" feature to include a dedicated dashboard tab and member-controlled unblocking. -Implement a "Report member" functionality with email alerts for admin and a reporting section in the admin area. -Allow users to manage their notification preferences from the dashboard. -Achieve Google Pagespeed optimization scores above 90 for both mobile and desktop. -Implement any necessary SEO optimizations. -Provide comprehensive documentation for all APIs. - Additionlay an admin area to manage memnbers and blog needs tobe devel...

I'm looking to enhance two key areas of my website and I need your expertise. - Supplier Product Upload and Search Functionality: Firstly, I would like to improve the way how suppliers c...product with different supplier prices by different suppliers), and how it is displayed to customers. - MLS Feed Integration: Secondly, I'm looking to connect my website to receive an MLS feed from another website. This would require you to setup the connection and ensure the data is accurately synced. Ideal Skills: - Proficiency in web development with a focus on ecommerce features - Experience with implementing search functionality improvements - Knowledge of MLS feed integration would be a bonus. - Laravel If you're confident in your ability to deliver on these two a...

I have a bulk of digital files that need to be accurately transcribed into a digital format. The files are all in English, so proficiency in English is necessary for this project. Ideal skills and experience include: - Proficient in English - Fast and accurate typing skills - Experience with data entry

I find myself in need of a skilled freelancer to restore my suspended Google Business account. My account was suspended due to exceeding the storage limit, and I have been unable to fix this issue myself. The professional perfect for this job should excel in: - Google Business account restoration - Dealing with suspension issues, specifically exceeding storage limit - Providing tips and guidelines on how to avoid future suspensions due to storage issues The task includes confirming the suspension reason, working towards resolving it, and ensuring resumption of the account. Knowledge on dealing with Google's support system would be highly advantageous. Looking forward to working with you.

I need a Google document to be converted into a Word document. The main reason for this is to make the content editable in Word. Key Requirements: - The Word document must mirror the formatting of a standard academic paper. This includes appropriate margins, font type and size, line spacing, and headings. - The Google document contains images and charts that also need to be accurately transferred into the Word version. It is crucial that these visuals remain intact and are not distorted during the conversion process. Ideal Candidate: - Proficient in working with Google Docs and Microsoft Word, ensuring that the formatting is correctly translated between the two. - Experience in handling academic documents, particularly in maintaining formatting consistency. - Skille...

Need an web hosting an expert to update my DNS settings. This is essential to ensure a smooth and seamless transfer. Ideal Skills and Experience: - Proficiency in DNS settings and configuration - Experience with migrating websites between hosting providers - Expertise in Google Workspace, particularly in setting up domain emails - Good communication skills to keep me updated on the progress and potential issues.

...multiplayer gameplay. Key Points: - The game will need to be developed using Unity and Photon Unity Networking (PUN) to facilitate the asynchronous multiplayer experience. - The gameplay should be optimized for mobile devices, ensuring a smooth and enjoyable experience for players. - The focus of the game will be on asynchronous multiplayer, meaning that players will be able to engage with one another without being required to be online simultaneously. This will require robust synchronization mechanisms and a well-thought-out game design. Ideal Skillset: - Proficiency in Unity and PUN is a must for this project. - Strong experience in mobile game development, with a portfolio of successful titles. - Prior experience with asynchronous multiplayer game development will be a signi...

I need a professional to prepare my income statement and balance sheet according to IFRS standards. My records are ready, and I only require a summary-level of detail. Ideal skills and experience include: - Proficiency in IFRS (International Financial Reporting Standards) - Proven track record in preparing financial statements, especially income statements and balance sheets - Detail-oriented and able to work with a high level of accuracy - Good communication skills to clarify any details for a summary-level reporting. This is a one-time project, but if successful, there may be more in the future.

I'm in need of an experienced audio technician, preferably with a background in voice manipulation and sound editing. As per the requirements of my project, I'm attempting to alter my voice recording to emulate that of another person, whom I have vocal samples from. Qualifying candidates should be adept at manipulating aspects such as pitch, tone, and accent to make my voice a convincing replica of the target voice. Key skills and experience: - Proficiency in sound editing - Prior experience with voice alteration tasks Please include the following information in your application: - Examples of past work, preferably including voice alteration projects. Despite the technical requirements being unspecified, proficient knowledge and use of appropriate software are un...

I want to design a car wash, and I want to import the goods from China, but I do not know what is the method, the best quality, and the method of communication. I want boxes for electric tanks that are made of carbon fiber, I want washing materials, I want water pumps, vacuum cleaners, all cleaning tools, and some other things. Ideal Skills: - Proficiency in Chinese - Experience with online dispute resolution - Strong communication skills - Understanding of international commerce and refund procedures

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:01"...

google and facebook promotion

I'm looking to leverage Azure document intelligence prebuilt models and train models to extract data from a variety of tax and financial documents. The extracted data needs to be exported into a Google spreadsheet. Additionally, I need an interface for users to easily upload these documents. Key Requirements: - Extract data from various financial documents: primarily focusing on Expense reports, W-2 forms, credit card statements, 1099s, and annuities. - Extract specific data from credit card statements such as Transaction amounts, Merchant names, Transaction dates, and also the ability to convert currency and combine rows. - Extract specific data from bank statements like Account balances, Transaction descriptions, and Check numbers. Ideal Skills...

As a service-based business owner, I am seeking assistance from an expert digital marketer or agency to improve our Google reviews to reach 500 reviews. Until now, we have been prompting our customers via follow-up emails. However, we would like to explore and implement more effective, innovative methods of encouraging our customers to leave reviews. Primed candidates should: - Have previous experience in increasing online reviews, particularly on Google, for service-oriented businesses. - Be adept in developing creative strategies for customer engagement. - Have excellent knowledge of email marketing and other possibly more effective methods. - Have the capacity to provide sustainable solutions: the goal here is to see a consistent growth in the number of high-rated...

I'm in need of an experienced Siemens PLC programmer to work on a project involving a S7-1500 model. The goal is to program various tasks related to servo systems. We have two servos linked with each other and have to move relative to one another. We have a 3d model of the assembly and should be simulated before delploying Key Requirements: - Expertise in Siemens PLC programming, specifically with the S7-1500 model. - Proficiency in programming servo tasks such as motion control, positioning, and synchronization. - Ability to work with existing hardware and servo motors setup. You should be able to understand and execute tasks related to motion control, positioning, and synchronization. Your experience with servo programming will be important, as the project is very much ab...

I'm in need of a single screen Android application. The primary function of the app is for users to log in ...Android application. The primary function of the app is for users to log in using their Facebook account. Upon successful authentication, the app should display the user's email address. Key requirements: - Single screen Android application - Facebook / Instagram / Google login integration - Display user's email address post-login Ideal freelancer for this project: - Proficient in Android development, particularly single screen applications - Experience with social media login integrations, specifically Facebook / IG / Google - Familiar with presenting user-specific information on Android applications - Excellent communication skills to clarify any a...

...Key Requirements: - The spreadsheet should allow me to input and monitor: - Investments (especially individual stocks) - Debt - Savings - Income - Expenses - Other category for miscellaneous expenses or income - I require a simple, user-friendly design that makes manual data entry easy and intuitive. Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets is essential. - Experience in financial tracking and net worth management is highly beneficial. - Understanding of stock market, investment tracking, and basic accounting principles is a plus. Delivery: - I expect the freelancer to deliver a comprehensive, error-free spreadsheet that meets the specified requirements. - The spreadsheet should be easily updatable and no...

...migration of content from my old Webflow website at to a new Google Sites webpage. Your main tasks will be: - Transferring all the website content, being the following pages: Homepage, Why Adjudication, Why AANZ?, The process, Articles, Forms (no need to move the links to the Dropbox forms though - I will upload fresh versions myself), Costs, Our Members, CCA 2002, Contact Us. - Replicating the design of the previous site as much as possible. However, given the differences between Webflow and Google Sites, some design changes may be necessary and can be made at your discretion. - Keeping the color scheme, photographs, typography and layout of sections consistent with the original site. Ideal candidates will have experience with both Webflow and Google Sit...

I need to create alternating colors for rows 19 to 28 and specifically for cells F29, F30, F31, and F32 using fill colors #F2F2F2 which is light gray and #F2F2F2 which is white. There will be a lot of hiding and unhiding of rows for this range and I need a solution that always displays alternating colors despite frequent hiding and unhiding of rows. Can anyone help me with setting up a conditional formatting rule that automatically alternates the row colors, regardless of row insertion, deletion, or hiding? https://docs.google.com/spreadsheets/d/1SwqtiYIrZdO8p6YOxKsOx5MTgE3qQwAajTKIImYWHmE/edit#gid=1503373653

Tenho site / blog com Post's em WordPress e preciso aprovar ele no google Adsense para monetizar-lo Conseguindo concluir o trabalho tenho outros sites para fazer o mesmo trabalho

PDF File converted to MS WORD File more than 300 pages Need ASAP

I'm searching for a skilled individual who can help me scrape data from a website. The data I'm interested in is text content and tables, specifically contact information. Ideal Skills: - Proficiency in web scraping tools - Strong experience with scraping text content and tables - Expertise in extracting specific information - Familiarity with structured data formats The contact information on the website is in a structured format. Your ability to navigate this and provide me with a clean, organized dataset will be crucial. Looking forward to collaborating with a detail-oriented and reliable professional. Attached is a sample format. The site is: Final file must contain all records for all schools on all pages

I need a uniquely developed tool for managing my Google reviews. The primary feature of this tool should be automating responses and providing analytics to monitor trends. It should also be able to alert me in real-time to any negative reviews. Key Features - Automated Responses: The tool should be capable of setting automated responses depending on the review sentiment. - Trend Analytics: It's important to be able to track review trends to gauge consumer satisfaction and adjust business strategies. - Negative Review Alerts: Immediate alerts on negative reviews for prompt response and reputation management. Ideal freelancers for this job should have experience in software development and familiarity with Google Review systems. Expertise in review monitoring, sentime...

As the project owner, I'm looking to transform an image file of a 2D floor plan into a to-scale outline floor plan. For this project, the digitized floor plan should include room measurements. While I didn't specify a preferred software, utilizing a program adept at architectural design, such as AutoCAD or SketchUp, would be beneficial. The ideal freelancer would possess: - Proficiency in architectural drafting software - Experience transforming image files into digital floor plans - Attention to detail, specifically regarding accurate room measurements.

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you available?

I have an extention that was working on Google Chrome and suddenly stopped working, most likely due to a Google Chrome update. It is programmed in JavaScript. Please help me fix and develop it, or create another extension similar to it in characteristics and features. Here is the link to download the extension: I will send you a link to download the extension so you can download it, try it, and let me know if it is fixed. Thank you

I'm looking for someone experienced in running projects from GitHub repositories "" to assist me in setting up and running the demo-k6-operator project on my Mac machine. Your guidance should help me to understand how this project works, which is my primary goal. Key requirements: - Expertise in running and configuring projects from GitHub repositories on Mac machines - Solid understanding of the demo-k6-operator project - Ability to provide clear, detailed instructions and guidance for running the project on my machine - Patience and willingness to explain concepts to help me understand the project better The specific challenge we may face is that I'm using a Mac CPU that is NOT Intel, so experience with this kind

Development a human anatomy VR application for oculus platform. When player in the app, they can choose a male or female anatomy. Then, choose the system function. Subsequently, anatomy of the system function will appear. Then player can click expand to isolate the parts with info panel to show name of organ. Then, player can close and choose other system or choose to see system of another gender. Arabic text of organ name and system name is to be provided prior or during development. Final delivery in apk.

Need to copy a powerpoint presentation from a video all the slides theres about 30-40 slides some just images and some some text

I need a skilled Wordpress expert to address a migration issue I'm facing with my website. Here's what I need: - **Migration Issue:** The problem I'm experiencing is related to theme and plugin compatibility following the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP, theme and plugin compatibility issues. Your abil...

I'm looking for a skilled professional to create a Web Assembly prototype, , using a small Delphi application that primarily showcases an interactive user interface. The aim is to target the prototype for web browsers. Key Requirements: - Creation of a Web Assembly prototype utilizing a Delphi application. - Focus on showcasing a simple interactive user interface The Prototype: - The user interface for the prototype is envisioned to be simple, consisting of basic elements. - The primary focus should be on the seamless integration of the Delphi application's functionality into a web browser environment.

...seeking a professional with experience in resolving Google Play account suspensions due to content policy violations. Key Project Details: - My account was suspended due to multiple violation of the content policy. - I have already reached out to Google for support. - I have received some documentation from Google regarding the violation and steps for reinstatement, but it's quite limited. Your Role: - Your primary role will be to guide me through the reinstatement process with Google, ensuring that all necessary steps are taken. - It's important that you have a clear understanding of the Google Play content policy and a track record of successfully reinstating suspended accounts. Ideal Skills and Experience: - Proven experience i...