How to compare two columns in different excel sheets using vlookupроботи

Мета: Професійне візуалізування квартири площею 71 квадратний метр із двома кімнатами, збільшення реалізму та якості порівняно з існуючою моєю роботою. Поточний стан: Одна кімната вже була візуалізована з матеріалами та освітленням. Однак, бажається більш реалістичне та високоякісне оформлення. Для довідки надано зразок цієї кімнати (мій зразок дитячої кімнати1 та мій зразок дитячої кімнати2) Додаткові довідкові матеріали включають фотографію іншої кімнати (бажаний рівень якості) та фактичну кімнату і основний файл ( та Sketchup+Vray+5+Interior+) Оригінальний файл SketchUp (квартира) буде доступний під час співбесіди. Вимоги: Коригування матеріалів: Детально налаштувати всі матеріали. Наразі я використовую V-Ray 6. Скріншоти всіхваших налаштувань V-Ray потрібно надати. Налаштування осв...

Необхідно розробити веб-застосунок та описати його роботу. Опис має бути в форматі одного розділу бакалаврської дипломної роботи. Більш детальний опис наведений в закріплених файлах.

Need to change the "Shipping City" field widget from a List to a Text field, under the field, display Help text. After writing the name of the city, compare the name and display the corresponding list of departments in the "delivery offices" field.

Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.

Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.

Transfer news websites advertising texts...

Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией

Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.

We're looking for a competent native English writer or editor to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with revising a trial article (paid).

I have an Excel sheet that requires daily data analysis using statistical methods. Key requirements: - Daily updates: The data in the Excel sheet will need to be analyzed using statistical methods and techniques on a daily basis. - Statistical Analysis: The main focus of the analysis will be on statistical methods. You'll be required to utilize various statistical tools to interpret the data and provide insights.

I'm urgently seeking a skilled developer to set up a Helios 2 Lidar camera for detecting human figures and calculating distances up to 10 meters. Key Requirements: - Proficiency in setting up and customizing Helios 2 Lidar camera - Mastery of object detection, specifically human figures. - Capable of implementing short-range distance calculation (up to 10 meters) The project demands someone who has a strong understanding of Lider camera configurations, and advanced skills in object detection and distance measurement methodologies. Your competence in creating systems to accurately detect human figures and calculate short-range distances will be the driving forces behind the success of this project.

I have several thousands PDFs that need to be read, interpreted and transcribed into a supplied spreadsheet format. It is important that you: 1) Have an existing team to help with a task that is estimated to take 2 weeks 2) Proficiency in PDF to Excel transcription 3) Ability to complete the task efficiently Applicants based in India only.

I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in...

I am looking for a detail-oriented professional to assist me in transcribing text data from Word Documents into an Excel sheet in alphabetical order. Specifically, you will be: - Handling text data from Word Documents - Accurately typing this data into an Excel sheet - Organizing this data alphabetically to aid in easy referencing Experience with data entry and a strong grasp of Microsoft Word and Excel is mandatory. I expect high attention to detail to ensure accuracy in data transcription and organization. Please submit your proposals detailing your relevant experience.

Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish

I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file

...accountant to manage tax related accounting tasks specifically GST and TDS filing for my 11-20 clients. - Responsibilities: - Filing GST returns - Filing TDS returns - Periodic accounting in tally for selected clients - Income tax return filing - Coordinating with clients on monthly basis for the documents The majority of my clients have less than 70 transactions per month and I use tally software, thus a good grasp of tally software and excel is necessary to handle the above tasks. - Skills and Experience: - Gst return filing experience - Proficient in tally software - Experience with handling multiple clients simultaneously - Knowledge of GST and TDS filing systems appeciated. This is an ongoing project and I am looking for a ...

I need a Zapier expert to create a flow that will automate the discount application process on my Shopify store from a Google Sheets CSV. Key Requirements: - The ZAP should identify new email addresses added to the CSV, and then add a customer tag "REGATHLETE" to them in Shopify. When the tag is added, they will be eligible to use that discount, as we have already created a customer segment for customers with the tag. - The ZAP must be able to add the tag both to new and existing customers in our Shopify database. Required Skills: - Proficiency in working with Zapier - Experience in creating Zaps with google sheets and matching CSV/data fields - Experience in automating processes and deal...

I'm in need of an Excel expert who can help me perform basic arithmetic operations for financial calculations. The purpose of the sheet is to analyze simple financial data, so you should have a good understanding of basic financial concepts. Key requirements: - Perform basic arithmetic operations in Excel for financial data. - Create standard tables and charts to present the analyzed data in a clear and comprehensible manner. The ideal freelancer for this job will: - Have a strong background in Excel, particularly in handling financial data. - Be able to create visual representations of data using standard tables and charts. - Be able to efficiently and accurately perform basic arithmetic ope...

...for leadership, a commitment to ethical standards, and a passion for problem-solving. If you're culturally aligned, possess stellar marketing and sales prowess, and thrive in fast-paced environments, this is your opportunity to shine! Embrace the challenge, make your mark, and redefine excellence in real estate! - Uploading photos and descriptions of properties - Sorting listings by location and price - Providing regular updates on availability - Scheduling site visits for potential customers - Providing customer support to potential buyers For the lead generation aspect, you'll be targeting first-time home buyers, investors, rental property seekers, and end users. To excel in this role, you should have experience in...

I'm in need of a professional data entry specialist to assist with entering numerical data into an Excel spreadsheet. The aim of this task is to organize the data in a clear, tabular format that can be easily read and interpreted. Skills & Experience: - Proficient in Excel - Strong attention to detail - Experience with numerical data entry The project demands precision in inputting the data, so only those who display meticulous attention to detail will be considered. An understanding of how to organize data in a tabular format is crucial. Please ensure you have relevant examples of similar tasks in your portfolio. Deliverables: - An Excel sheet filled with the provided...

Χρειάζομαι άτομο για τη δημιουργία database σε excel

I am in need of an Excel professional with an intermediate level of proficiency to assist with various tasks on my project. The specifics of these tasks are open for discussion, therefore a degree of flexibility and adaptability is required. You should ideally have proven experience with data analysis, spreadsheet automation, and formula creation despite the fact these haven't been specified outright. An overview of your past relevant projects included in your bid would be highly appreciated. Convince me with your technical prowess and past success stories.

...experienced freelancer to conduct an in-depth research on the electric instant and storage water heater market in Bahrain. The task involves a comprehensive analysis of: Requirements (must live in Bahrain Manama): 1. Identify Top Retailers: List the top 5 major home appliance retailers in each country. 2. Document all Water Heater Brands in the store (focus on electric instant and storage water heaters): Visit 1x store (pick the biggest and most popular store) of each Major Retailer. Then compile a list of popular water heater brands, including pictures, prices, and key features. Highlight the most sought-after brands in each country. 3. Online Platforms: Document online platforms selling water heaters, providing links to their we...

I need a proficient individual to assist with data entry into an Excel sheet. The data to be entered is purely textual, derived from printed documents and requires no complicated formatting. Key Responsibilities: - Transfer text data from printed documents to Excel - Ensure accuracy of data entered - Follow simple formatting guidelines Ideal Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail - Experience with data entry - Fast typing speed - Experience working with printed documents This project is ideal for freelancers with a knack for accuracy and speed in data entry, particularly in Microsoft Excel. It involves simple one-word entries and familiarity with printed documents is a...

The draft literature review will be assessed on how well you address the following criteria: Relevant choice of four (4) journal articles related to the topic of the qualitative study - factors affecting hotel customer satisfaction. Correct use of APA7 Referencing both in-text and in the reference list Clearly and succinctly explaining the content of the article and key findings within the word count of 500-600 words (excluding the reference list) Ability to compare and contrast the four (4) journal articles (published no earlier than 2012) Ability to accurately identify any limitations of each study/paper (within the journal articles) Must use 12 font, Times New Roman, 1.5 spacing.

...versatile freelancer to conduct an in-depth survey on the market of electric instant and storage water heaters in Brunei. The focus will be the trifecta of evaluation - market demand, product features, and consumer needs. Requirements (MUST LIVE IN BRUNEI Bandar Seri Begawan): 1. Identify Top Retailers: List the top 5 major home appliance retailers in each country. 2. Document all Water Heater Brands in the store (focus on electric instant and storage water heaters): Visit 1x store (pick the biggest and most popular store) of each Major Retailer. Then compile a list of popular water heater brands, including pictures, prices, and key features. Highlight the most sought-after brands in each country. 3. Online Platforms: Document online pla...

I'm in need of a custom Python parser using the pylatexenc library. It should mainly feature: - Special Feature Parsing: This parser must be able to parse through figures, tables, and equations specifically, while remaining in original LaTeX format. - Format Conversion: convert to simple text The ideal candidate for this project will have proven Python skills, familiarity with the pylatexenc library, and knowledge of LaTeX. They should also have experience with custom parser creation, and be familiar with converting LaTeX into other formats. Note: extensive testing on sample latex projects needs to be conducted to make sure its generalizability.

...looking for a freelancer to conduct an in-depth market survey on electric instant and storage water heaters in Bangladesh. The focus will be the trifecta of evaluation - market demand, product features, and consumer needs. Requirements (Must live in Bangladesh Dhaka): 1. Identify Top Retailers: List the top 5 major home appliance retailers in each country. 2. Document all Water Heater Brands in the store (focus on electric instant and storage water heaters): Visit 1x store (pick the biggest and most popular store) of each Major Retailer. Then compile a list of popular water heater brands, including pictures, prices, and key features. Highlight the most sought-after brands in each country. 3. Online Platforms: Document online platforms ...

Necesitaria el código para integrar en mi web de un formulario que los clientes puedan rellenar y me vuelque los datos a un excel de google, o a varios pdfs

I am in need of an expert in Excel data entry. The objective of this project is specifically for data entry purposes. The task involves keying in customer information into Excel. Familiarity with this type of data is a big bonus. Attention to detail, fast typing speed, and meticulousness are skills that are necessary to successfully complete the task. Additionally, extraction of specific information will be required. More specifically, identifying trends within a given period from the input data. Therefore, a keen eye for detail and an analytical mind are crucial for this job. In conclusion, if you have experience handling customer information, know your way around Excel, have a knack for finding patterns among data, and c...

We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.

I have an Excel sheet that needs to be filled with a combination of text and numbers. The sheet is not too large, falling within the 10-50 rows and columns range. I would also like the data to have a specific formatting, including the use of particular fonts and colors. Key Points: - The task mainly involves typing text and numbers into an Excel sheet. - The sheet consists of 10-50 rows and columns. - The final output requires specific formatting with designated fonts and colors. Ideal Skills and Experience: - Proficiency in Excel and data input. - Understanding of basic design principles for formatting. - Attention to detail to ensure correct typing and formatting. - Able to follow specific instructions for fon...

...expert in Microsoft Power Automate to set up 3 automated workflows as an intitial test: Flow 1: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in another outlook 365 ...

I need assistance with entering data into an Excel sheet. Ideal Skills: - Proficiency in Excel - Meticulous attention to detail - Fast, accurate typing skills - Experience with data entry and data organization Please note, the specific data format will be provided.

I have a project that involves typing text and numbers into an Excel sheet. - **Data Type**: The data is a mix of text and numbers. It's nothing overly complex - just straightforward typing. - **Sheet Size**: It's a medium-sized spreadsheet, containing 10-50 rows and columns. - **Formatting**: I don't need fancy formatting. Just simple data typing. Ideal candidates for this project would: - **Experience**: Demonstrated experience with data entry tasks in Excel. - **Accurate Typing**: Attention to detail is crucial, as the data is critical. - **Efficiency**: Completing the task in a timely manner is important for this project. Looking forward to working with you!

...looking for an experienced pixel artist capable of creating sprite sheets for a top-down style game. You'll be working on different characters over time in a fantasy "Warcraftian" style. The tasks include: - Creating sprite sheets for static sprites. Animations req'd Heroes: Walk, Run, Idle, Melee, Ranged, Aura/Area,Summon, Disappointment,Celebration,Victory,Damage,Death. Mobs: Walk, Melee, Ranged,Damage,Death. Ongoing work available. Ideal candidates should have experience working with top-down pixel art and creating dynamic game animations. A detailed understanding of character movement and expression in pixel form are essential. An eye for detail and the ability to interpret and translate character traits into sprite ...

I need someone to create an external link in my Excel file to a PowerPoint presentation. The data in the Excel file will be updated daily. Requirements: - Creation of an external link from Excel to PowerPoint - Daily updates to the Excel file - No automatic updating of PPT needed. Manual updates are fine Ideal Freelancer: - Proficient with both Excel and PowerPoint - Experienced in creating external links - Comfortable with daily updates - Ability to follow instructions precisely.

Analizar Tabla de calculo de probabilidades de internet. Hacer lo necesario para comprender los calculos internos y poder replicarlos es un libro de excel. El trabajo comprende la hoja de Excel y la explicación de los calculos implicitos.

We need someone with experience in supabase and react native/expo, the main task is develop the business logic that we need in the app. Features: Authentication Post Post detail Post filter Create offers for those post List of offers and filter View users profile and info List of transaction's Invoices list and detail Wallet like system (deposit and withdrawal) List of tables and columns: Profile, 9 columns Homework, 10 columns Offers, 4 columns Review, 6 columns Invoice, 10 columns Wallet, 7 columns Transactions, 8 columns Bank list, 4 columns Subjects, 4 columns The app is done in react native, we have the project with all design implementation, just need to integrate with the backen...

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

I'm in need of a skilled professional to establish and maintain a seamless connection between my GoDaddy site () and Digistore. The primary objective of this relationship is to boost the sales of my product through affiliate marketing on Digistore. Experience with javascript needed. Key Responsibilities: - Facilitate the connection between Digistore and GoDaddy, ensuring that my product is promoted effectively by the affiliates on the former. - Implement strategies to increase the sales of my product on Digistore through the affiliate marketing program. - Create and manage support materials for the affiliates. This includes pre-written social media posts and product information sheets. Ideal Skills and Experience: - Proficiency in setting up...

I'm in need of a tool that can convert PDF voter lists into Excel in a text format. Here's a breakdown of what I'm looking for: - Conversion Style: I'd like the tool to convert the PDF voter list by combining all columns into a single table. This will make it easier for me to work with the data in Excel. - Error Detection: It's important to me that the tool can automatically detect and correct errors in the text. Nevertheless, I also want to have the ability to manually review and correct the text to ensure its accuracy. - Language: In this case, the tool only needs to handle English language texts. You don't need to worry about incorporating mult...

I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.

I need assistance with ex...need assistance with extracting data from PDF files into Excel. The task involves: 1. Converting PDF to Excel: Use Adobe Pro to convert tabular data from PDFs into Excel. You can use cracked version to do this. 2. Formatting: The existing tables mostly match the required format but will need adjustments a. Remove unnecessary columns and rows and map the right column names. b. Convert hierarchical data to a flat format. There are 200 PDF files (10 of which have been already done but you can verify them as well), each averaging 4-5 pages (many files have 1-2 pages but there are some with more than 20 pages, averaging to around 4-5 pages per pdf) Here is a google doc that contains references...

...individual to assist me with several key tasks. 8am - 5pm PST availability, full time role. Key Responsibilities: - Data Analysis: You should be able to dissect and interpret a variety of data sets, particularly surrounding sales, leads, and conversion rates. - Report Generation: Using Excel or Google Sheets, you will be responsible for creating detailed reports on sales performance, lead generation, and conversion rates. Ideal Skills and Experience: - Fluency in Excel/Google Sheets - Previous experience working as an executive or virtual assistant for sales managers or VP of sales, ensuring you understand the requirements and demands of the role - Exceptional attention to detail and a track record of maintaining high stan...

I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is ...

I need an online store data extraction specialist to pull key information (product name, price, and barcode number) from a particular online store. - The extracted data should be delivered in an Excel spreadsheet. - This is a one-time task; there is no need for continuous extraction. It's essential that you're proficient in web scraping techniques, able to navigate through the store's pages, and extract the right data accurately. Experience with online store data extraction is preferable. Please indicate any relevant past projects in your bid. Looking forward to working with a pro who can deliver quality results efficiently.

I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.

I need an Excel expert to perform a specific data analysis task for me. - The job involves conducting an analysis where two cells are fed values from 1-100. - The task is to find the highest value in a third cell, based on the values of the first two cells. - The values in the two initial cells should be generated using a combination of user input and random generation. Ideal skills and experience for this job include: - Proficiency in advanced Excel functions, particularly those related to data analysis and cell value calculations. - Experience with probability, permutation, and combination would be a plus. - A strong understanding of statistical analysis and data interpretation. This project would be ...