How to match two columns in excel using vlookupdela

Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server

Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

need help with spreadsheet formula

I'm looking for a skilled front end developer to help me create a dashboard focused on data visualization,The primary objective of this project is to develop a robust data virtualization tool capable of interpreting, displaying, and analysing collision avoidance system data extracted from log files. This tool will enable users to load log files or Excel files, interpret the data, generate reports based on specified parameters, and visualise the insights using a web application or Power BI interface.

I need a skilled Excel user to help me format a single spreadsheet and create formulas to automate some calculations. Key Responsibilities: - Format the spreadsheet to make it visually appealing and easy to read. - Create formulas to automate calculations based on the data input. - Ensure the spreadsheet is user-friendly and easy to update. Ideal Skills and Experience: - Proficiency in Excel, particularly in data formatting and formula creation. - Prior experience in handling data-heavy spreadsheets. - Strong attention to detail to ensure accurate data processing. - Ability to work independently and deliver the project in a timely manner.

I am seeking a meticulous architect to create a modern two-storied house plan with only master upstairs rest of 3 bedrooms to be at the ground floor along with living at the front . Pool and alfresco Key Requirements: - Proficiency in modern architectural design concepts. - Proven experience in creating house plans for permit applications. - Provide accurate dimensions and scaling for two floors. - Ability to adhere strictly to building codes and regulations. - Excellent communication and timeliness in delivery. This application requires you to have a keen eye for detail in modern design and a comprehensive understanding of permit application requirements. Previous experience in this particular field wi...

I am searching for a knowledgeable expert in Microsoft Excel who can assist me with a variety of tasks. Specifically, I require aid with formulas and functions, and formatting and design. More specifically, I need assistance with summation and averages, and VLOOKUP and INDEX-MATCH commands. The ideal candidate would have substantial proficiency and experience with Excel, with an emphasis on utilising complex formulas and creating aesthetically appealing and comprehensible spreadsheets.

...an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). Th...

I'm in urgent need of a WordPress expert to optimize my website's mobile version. The desktop version is running at 95% speed, but the mobile version is significantly slower, scoring only 66%. I need the mobile version to be optimized to match the desktop speed ASAP. We already use the paid plugin WP Rocket. Key Requirements: - Improve mobile page speed significantly to match the desktop version. - Prioritize optimization of images, heavy themes or plugins, and unoptimized JavaScript and CSS. - Ensure the mobile version is fully functional post-optimization. Ideal Skillset and Experience: - Proficiency in WordPress and understanding of mobile optimization techniques. - Strong experience in optimizing images, videos,...

Project Background: We envision an innovative platform designed to transform how organizations, including startups, nonprofits, researchers, and small businesses, search for and apply for grants and funding. By leveraging advanced AI technologies and a user-friendly interface, it aims to simplify and enhance the funding acquisition process. Objective: The primary objective of this project is to develop the Minimum Viable Product (MVP) using the Bubble platform, incorporating the capabilities of the Perfect AI Software Template. This MVP will validate the concept by offering essential functionalities such as AI-driven funding opportunity matching, interactive user profiling through an intelligent quiz, and efficient application assistance. Scope of Work:...

...for skilled frontend developer to duplicate an existing website template for my e-commerce store. The old site has performance issues and loads quite slow. There for we have decided to switch from OpenCart to Bagisto store. Responsibilities: - The template needs to match our existing site at least at around 90% ! - No perfection issues at our side - Accepting improvement ideas - There is no need to made it ready for Bagisto, our need is only the CSS and base HTML with dummy content. - Duplicate an existing website to stand alone TailwindCSS template. - Ensure the template is Responsive as our main target is mobiles but desktop as well. - Implement few dummy pages: Homepage, Category, Product, Search, Login / Account. Required Skills and...

I'm looking for a professional email marketing agency that can manage an email campaign for me. Essential skills/experience required: - Proficiency with email service like mailchimp or similar - Previous experience in email marketing, particularly in promoting products - Ability to send follow-up email Key deliverables: - Sending out 350 emails using our email id - Creating and sending follow-up emails - Providing a detailed report on the campaign's performance Please note, I have a template for the emails already. I also have the database of the people to send out in excel format - company name, email, first name and last name - so it should be easy

...individual to assist in designing a compelling, professional corporate PowerPoint presentation, with an objective of introducing my company to potential clients. This slideshow should primarily focus on my company’s products and services, demonstrating our competencies and capabilities effectively. Key Requirements: - Deep understanding of PowerPoint design, and good eye for attention-grabbing visuals - Ability to translate corporate and product information into engaging content - Experience in creating corporate PowerPoint presentations is a major plus Specific Elements: - The presentation should showcase our capabilities, the products or services we excel in. - While not necessary, a designer who can incorporate well-craft...

I'm in need of an experienced Excel professional who can help automate some daily tasks for me. Key Requirements: - Automate tasks: I need an expert who can help me automate some of the manual tasks that I perform daily on Excel. The aim is to speed up the process and potentially reduce errors. Additional Information: - No external interactions: The automation should be self-contained within Excel. There's no need for it to interact with any external databases or applications. Ideal Skills and Experience: - Advanced Excel Skills: The successful candidate should have a proven track record of automating tasks in Excel. - Experience with Daily Automation: Since this is a daily task, experience in setting up s...

I'm in need of someone who can help me with lead generation. I'm looking to target specific industries in the process and would like to focus on the following segments: - Manufacturing & Machine Industry - Energy Providers - Insurances - Webshops ALL COMPANIES MUST BE BASED IN THE COUNTRY OF SWITZERLAND. COMPANIES SHOULD BE OF SMALLER TO MEDIUM SIZE, IDEALLY BETWEEN 10-99 EMPLOYEES. The leads I'm interested in should be responsible for digital transformation, digitisation, or be a product manager/owner. In small companies, this might be the company owner/CEO. In a bit larger companies (e.g.> 50 employees), this could be a separate position, which could either have the title of "Digital...something&...

I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.

I'm looking for a skilled professional to assist with a data entry project. The aim is to input various contact details into a spreadsheet, with a range of essential and additional information. Key responsibilities include: - Entering Name, Email IDs, Phone/Mobile Numbers, and Website Links for each entry. - Including LinkedIn profile links, Other correlated details, and Remarks for each entry. Ideal freelancers for this project should: - Have a background in data entry. - Possess excellent attention to detail. - Be able to work efficiently and accurately. - Familiarity with LinkedIn and other social media platforms. - Experience working with data on spreadsheet platforms like Excel or Google Sheets.

I'm looking for a skilled professional who can convert a provided design into a PDF document using HTML format. The attached format should be replicated in the PDF. I will supply all the necessary content and images for the document. Key Requirements: - The PDF should include a header and footer as per the design. - Proper formatting and tables should be implemented. - Images and logos within the document should be accurately included. Skills and Experience: - Proficiency in HTML and experience in creating PDF documents. - Knowledge of would be advantageous. - Ability to replicate a design accurately in a PDF format. - Attention to detail to ensure all elements are correctly positioned. Budget: The fixed budget for this proj...

I'm looking for an illustrator to create an image that will complement our existing logo. The primary use of this illustration will be for social media posts with the goal of enhancing our brand awareness. The ideal candidate should be able to: - Create a minimalistic illustration style. - Match the color scheme with our existing logo.

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

Key Requirements: - Create corporate video with voice over for an engineering factory - Inputs will be provided in the form of images and short videos - Time span of the video will be around 3 minutes - Voice over is required Ideal Freelancer: - Experience in creating corporate videos, ideally with a technological or engineering focus. - Proficiency in video editing and animation software. - Strong skills in voice over and script writing. - Make videos using AI

Deseo un sistema de ventas que me permita crear una base de datos para mis clientes , registrar inventario de bidones , registrar los pagos en efectivo Transferencia y los que deben , registrar compras , Cuento con un cuaderno con informacion de los meses de enero febrero y marzo quisiera ingresar esa informacion . Adjunto un formato de excel donde llevo prácticamente ingresando datos manuales , necesito llevar control de los ingresos y egresos

I'm in need of an Excel Calculation Expert. I have data spreadsheets that need to do the calculations using Excel Your primary task will be to: - I've dataset (excel file), that needs to do the calculation using excel - Once it done then you need to write report as per following requirement Deadline: 10 hours or less

I need an Excel expert to assist me with various tasks involving data analysis and calculation 1. I have data and you need to do the historical data 2. After that you are required to write report as per requirement and instruction 3. Deadline: you may take 8-10 hours

I am seeking a talented pop vocalist with a knack for creativity. This exciting project involves converting a poem into a song. Key Responsibilities: - Create a pop melody for a specified poem - Bring the poem to life through song. Ideal skills: - Previous experience in the Pop genre - Strong vocal abilities - Previous songwriting experience or ability to translate poetry into musical form. This is a fantastic opportunity for those who excel in conjuring up catchy pop melodies and are skilled at breathing new life into written words.

I'm looking for a master plumber to provide comprehensive plumbing services for the finish out of a restaurant commercial space. I need pipe repair, drain cleaning, and water heater installation expertise. I also need someone who can assist with: - Kitchen plumbing setup - Seating area plumbing (if required) - Restroom facilities plumbing To understand the project specifics, you'll need to request plans and discuss details with me. I expect a skilled, experienced commercial plumber who is familiar with the unique requirements of restaurant plumbing. Please bid if you can match these requirements.

...skilled graphics designer to create custom designs for my Wordpress site. The overall visual theme I'm aiming for is elegant and sophisticated. Key requirements include: - A full site graphics design. - In-depth understanding of how to design in a way that's consistent with the elegant and sophisticated theme and historical nature of the content, it is from World War 2 Era World History and Jewish and Christian Religious Themes - Experience with creating custom graphic elements for websites, not just relying on templates. - A good eye for typography, as it's a crucial aspect of the design. - Familiarity with WordPress is a plus, as the designs will be implemented on a WordPress site. The website in question is tenboomthemusica...

I need a data entry specialist to help me with a simple task of entering data into spreadsheets. Ideal Skills and Experience: - Proficient in data entry, specifically into spreadsheets, with a keen eye for detail - Experience working with Excel or similar tools - Ability to maintain accuracy and meet deadlines - Good communication skills and reliability Looking forward to working with a professional who can complete the task efficiently and accurately.

In this project, I need a freelancer who can meticulously manage data entry tasks. Ideal Skills: - Strong data entry skills, specifically with text data. - Advanced knowledge of Excel and data management within it. - Ability to understand and follow custom data organization instructions. Job Summary: - Enter text data into Excel format, understanding the importance of accuracy. - The data must be organized in a specific, custom order that I will provide. - Experience in similar jobs and a keen eye for detail will be highly beneficial.

For this project, I have a single digital photo of 18MP resolution (RAW) that requires a specific edit. I need a skilled photo editor to professionally extend the right side of the photo, or "stitch", without compromising the overall quality and feel of the original image. Skills and Experience Required: - Proficiency in photo editing software, especially with photo merging and stitching techniques. - A sharp eye for detail to blend and match the original image for a seamless extension. - Experience with handling RAW images. - Ensure final output maintains its high resolution quality.

I'm in urgent need of a skilled freelancer who can help me set up a system to remotely control a headless Windows virtual machine using graphical applications. The virtual machine will specifically be running WhatsApp Desktop. Key project components: - Setting up a Windows virtual machine - Configuring it to run WhatsApp Desktop - Implementing a system for remote control Ideal Skills: - Proficiency in Windows OS - Experience with virtual machines, particularly setting up headless ones - Knowledge of remote access software - Previous experience setting up and using WhatsApp Desktop This project has a tight deadline, and I need someone who can start immediately and complete the task ASAP. The successful freelancer will have excellent communi...

I'm in urgent need of a skilled content writer who possesses strong proficiencies in Microsoft Excel. The primary task will involve generating written material for my organization, with an additional responsibility requiring accurate invoice creation. Your responsibilities in detail: - Generate compelling content that aligns with my organization's goals and objectives. - You would also be responsible for creating invoices using Microsoft Excel. Ideal qualifications and skills: - A strong grasp of the English language with excellent writing skills. - Prior experience with content writing and invoice creation. - Expert understanding of Microsoft Excel, particularly when it pertains to invoice creation.

...GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to the...

I am in need of a talented designer to give my Canva brochure a professional upgrade. It should stand out as fun, readable, and professional and should appeal to the general public. Its 45 pages long (43 plus the front and back) and is a guide/brochure for buying in a particular area of Spain. Its in English as its for UK and US readers primarily. Right now, I have all the word content in there. However, when trying to improve how it looks, I realise I have zero creativity in that department I'm not looking for anything too spectacular, but must be something that doesnt look like a 10 year old made! Ideal skills and experience: - Proven expertise in professional design and familiarity with Canva - Strong under...

...detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure acc...

...developer to create a Bootstrap filter table with advanced filtering functionality. The table should be responsive and able to handle multiple columns. Here are the specific requirements for the project: *** DO NOT BID ON THIS PROJECT IF YOU HAVE NO UNDERSATNDING OF BOOTSTRAP OR SOME IDEA OF THIS PROJECT. A TEMPORAY SKETCH LAYOUT WITH A SAMPLE WITH BE APPRICATED TO HELP US IN MAKING A DECISON WHO TO AWARD THE PROJECT TO. *** Functionality: - Advanced filtering: The table should allow users to filter data based on multiple columns. - Custom filtering: Users should be able to specify criteria for filtering. Responsiveness: - The Bootstrap table should be responsive, ensuring optimal user experience across different ...

...see it. Design Preferences: - A combination of both text and symbols in the logo is preferred. The text should be clear and easy to read, while the symbol should be designed to match the soothing theme. - The color palette is open for your creative input. While I've not selected specific colors, I'd like the colors you choose to reflect the feelings of relaxation and well-being. Ideal skills and experience: - Proven experience in logo design, specifically for wellness, spa, or similar industries. - Strong understanding of color psychology, particularly as it relates to feelings of relaxation and well-being. - Ability to create a balanced and aesthetically pleasing combination of text and symbols. The ultimate goal is...

...hours of personalized 1-on-1 training to manage your site effectively. Key Features Professional Design: Choose from stunning templates, customized to match your brand. Contact Form Integration: Seamless communication with your audience. 3 Hours of Training: Learn to update content and manage your site confidently. Mobile Optimization: Ensure a smooth experience across all devices. SEO Best Practices: Boost online visibility with basic SEO strategies. Domain Connection: Link your existing domain for a branded online presence. How It Works Consultation: Understand your business goals and requirements. Website Development: Choose a template that fits your vision. Content Integration: Provide your content, and we'll make it engaging. Training Sessi...

Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. L...

I'm in need of a seasoned freelancer who can help design a professional and engaging newsletter targeted specifically at newby freelancers. This is a recurring project, and I require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make the newsletter visually appealing and professional. - Audience Focused: The content of the newsletter should be tailored and engaging for experienced freelancers, providing them with valuable insights and tips that can help them excel in their freelance careers. Ideal Skills and Experience: - Proven experience in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools for manag...

...have a multi-story 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 ...

...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. - Ability to troubleshoot...

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

As the client, I am search of a seasoned 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, prioritiz...

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.

I'm looking for a professional who can guide me on ...filming a meeting with 3 iPhones and wireless lavalier mics. The goal is to have the video and audio well-synchronized for post-production editing. Key Responsibilities: - Set up 3 iPhones for optimal video quality - Configure wireless lavalier mics for clear audio - Advise on real-time synchronizing of video and audio Ideal Skills and Experience: - Extensive experience with video production - Proficiency in using iPhones for filming - Knowledge of wireless lavalier mic setup - Understanding of real-time video and audio synchronization Meeting Length: Less than 1 hour Environment: Indoors with controlled lighting I need assistance in all aspects of this setup, including ensuring that the video and au...

I'm in need of a skilled individual or team to help me with a machine learning project focusing on image classification. The purpose of the models is primarily for classification, not any other form of analysis. Key Requirements: - The models will be working with image data, so experience in deep learning and image processing is a must. - The processing needs to happen in real-time. It's a critical aspect of the project. Ideal Skills: - Proficient in image processing and deep learning techniques. - Experienced in developing and deploying real-time machine learning models. - Strong background in image classification and neural networks. If you have a portfolio or past project that demonstrates your abilities in the...