19 VLOOKUP Jobs in India

Job Title: Corporate Quality MIS Analyst – Automotive / Wiring Harness

Company: Vi-Son Cables Pvt. Ltd.

Location: Mumbai – Corporate Office

Experience: 3–7 Years

Industry: Automotive / Auto Components / Wiring Harness

Job Summary

We are looking for a Quality MIS Analyst with experience in the Automotive, Wiring Harness or Auto Components industry to manage Corporate Quality MIS and reporting. The role will be responsible for consolidating quality data from all plants, analysing KPIs and preparing reports and dashboards for Management.

Key Responsibilities

• Consolidate plant-wise Quality MIS, KPIs and performance reports.
• Analyze PPM, rejection, rework, FPY, customer complaints, CAPA and 8D.
• Prepare MIS reports, dashboards, trend analysis and Management presentations.
• Coordinate with Plant Quality Teams for timely and accurate data.
• Identify quality trends, deviations and improvement areas.
• Maintain standardized Corporate Quality MIS and databases.

Key Requirements

• 3–7 years of experience in Automotive / Wiring Harness / Auto Components Quality.
• Strong knowledge of Quality MIS, Quality KPI reporting and data analysis.
• Proficiency in MS Excel, Pivot Tables, VLOOKUP/XLOOKUP, dashboards and PowerPoint.
• Knowledge of 7 QC Tools, 8D, CAPA and Root Cause Analysis.
• Strong analytical, coordination and communication skills.

We are looking for a detail-oriented Shopify Specialist to manage product uploads, catalog updates, variants, images, metafields, collections, pricing, promotions, and quality checks on Shopify.

This role is ideal for someone who has hands-on experience with Shopify Admin, Matrixify or Shopify CSV, Excel/Google Sheets, and large product catalogs. The person should be highly accurate, process-driven, and comfortable working with bulk product data.

Key Responsibilities

• Create, update, and maintain products in Shopify.
• Manage product titles, descriptions, handles, vendors, product types, tags, SKUs, variants, prices, compare-at prices, and inventory settings.
• Work on bulk product uploads and updates using Shopify CSV, Matrixify, or similar tools.
• Manage product-level and variant-level metafields.
• Update availability, lead time, media gallery, product information, bundle details, and other custom fields.
• Upload, replace, reorder, and validate product images.
• Match product images, variant images, image URLs, and metafield image references.
• Create and update manual and automated collections.
• Support sale collections, promotional updates, merchandising changes, and product sorting.
• Perform QC after uploads to ensure product pages are accurate and complete.
• Prepare error reports, missing data reports, upload reports, and correction files.
• Coordinate with internal teams, clients, image editors, QC teams, and managers.

Required Skills

• Hands-on experience with Shopify Admin.
• Strong understanding of products, variants, collections, tags, images, and metafields.
• Experience with Shopify CSV, Matrixify, or bulk import/export tools.
• Strong Excel/Google Sheets skills including VLOOKUP, XLOOKUP, filters, formulas, duplicates, and text cleanup.
• Ability to handle large product catalogs with high accuracy.
• Good understanding of e-commerce catalog operations.
• Strong attention to detail for SKUs, pricing, images, variants, and metafields.
• Ability to follow SOPs and complete work within deadlines.

Preferred Skills

• Experience with Matrixify.
• Experience with Shopify metafields and file/image reference metafields.
• Knowledge of automated collections, product tagging, and Shopify bulk editor.
• Basic understanding of image naming, image URLs, Shopify media, and CDN links.
• Experience working with Google Drive, task trackers, and client instruction sheets.

Ideal Candidate

You are a good fit if you:

• Notice small data mismatches quickly.
• Can work independently after understanding the process.
• Do not blindly upload data without checking.
• Can manage repetitive but accuracy-heavy tasks.
• Communicate clearly when something is missing or incorrect.
• Take ownership of final product page quality.
• Are comfortable working with deadlines during uploads, promotions, or migration projects.

Experience Required

• 1–3 years of experience in Shopify catalog management, e-commerce operations, product upload, or catalog QC.
• Freshers with strong Excel skills and e-commerce understanding may be considered for junior roles.

Greetings from zealous!

Role: MIS Executive

Location: Chennai

Experience Required: 1 to 2 Years

Preferred Candidate: Male Candidates Only

Job Description

We are looking for a MIS Executive with 1–2 years of experience to join our team in Chennai. The ideal candidate should have strong expertise in Advanced Excel, MIS reporting, and data management.

Key Responsibilities

• Prepare and maintain daily, weekly, and monthly MIS reports
• Generate accurate reports and dashboards for management review
• Analyze large sets of data and present meaningful insights
• Use VLOOKUP, HLOOKUP, Pivot Tables, and advanced formulas for data analysis
• Develop and maintain Excel macros / VBA automation
• Ensure data accuracy and timely submission of reports
• Coordinate with internal teams for data collection and reporting requirements
• Create and update trackers, performance reports, and management dashboards
• Support business teams with ad-hoc reporting and analysis

Required Skills

• Strong knowledge of Advanced Excel
• Hands-on experience in:
• VLOOKUP
• HLOOKUP
• Pivot Tables
• Macros / VBA
• Advanced Formulas
• MIS Reporting
• Data Analysis
• Good understanding of reporting formats and dashboards
• Strong analytical and problem-solving skills
• Good communication and coordination skills

Qualification

• Any Graduate
• 1 to 2 years of relevant MIS / Reporting experience

Preferred

• Male candidates preferred
• Immediate joiners are an added advantage

Position : Executive / Sr. Executive / Assistant Manager – MIS & Reconciliation

Industry : Fintech

Job Location : Gurgaon

Experience :

• Executive / Sr. Executive : 3–6 Years
• Assistant Manager : 5–8 Years

Role Overview :

We are looking for a detail-oriented and analytical MIS & Reconciliation professional to manage management reporting, account reconciliations, data validation, and periodic MIS activities.

The role will be responsible for preparing accurate and timely MIS reports, identifying and resolving reconciliation discrepancies, maintaining data integrity, and coordinating with cross-functional teams. The position will also contribute to process improvement and reporting automation initiatives.

Mandatory Skills :

MIS Reporting, Account Reconciliation, Advanced Excel (VLOOKUP, HLOOKUP, XLOOKUP, Pivot Tables, COUNTIF/COUNTIFS, SUMIF/SUMIFS), Data Analysis, Data Validation, Financial Reporting, and Discrepancy Resolution.

Key Responsibilities :

• Collect, consolidate, validate, and analyze data from multiple sources for MIS reporting.
• Prepare and circulate daily, weekly, monthly, and periodic MIS reports for management review.
• Perform account, transaction, and ledger reconciliations and investigate discrepancies.
• Identify data mismatches, exceptions, and reconciliation breaks and ensure timely resolution.
• Maintain high standards of data accuracy, completeness, and integrity across reporting activities.
• Coordinate with Finance, Operations, Business, and other internal teams to collect and validate required information.
• Maintain and update MIS dashboards, trackers, and reporting formats as required.
• Support audit requirements by preparing relevant reports, reconciliations, schedules, and supporting documentation.
• Ensure adherence to defined reporting processes, controls, and timelines.
• Identify opportunities to improve reporting processes and reduce manual efforts through automation and standardization.
• Assist in developing and maintaining automated MIS reports using advanced Excel and other relevant tools.
• Track key operational and financial metrics and highlight significant variances or exceptions to management.
• Maintain proper documentation of reports, reconciliation workings, processes, and controls.

Key Performance Indicators / Success Criteria :

• Accuracy and timely submission of MIS reports.
• Timely completion and accuracy of account/transaction reconciliations.
• Effective identification and resolution of discrepancies and exceptions.
• Data integrity and adherence to reporting standards.
• Quality of coordination with cross-functional stakeholders.
• Reduction in manual reporting efforts through process improvement and automation.
• Timely support for audits and management reporting requirements.

Mandatory Skills :

Advanced Excel

Strong hands-on experience with Microsoft Excel, including :

• VLOOKUP / HLOOKUP
• XLOOKUP
• COUNTIF / COUNTIFS
• SUMIF / SUMIFS
• Pivot Tables
• Conditional Formatting
• Data Validation
• IF / Nested IF
• INDEX-MATCH
• Data cleaning and consolidation
• Large-data-set handling and analysis

MIS & Reconciliation

• Strong experience in MIS preparation and management reporting.
• Hands-on experience in account / transaction / ledger reconciliation.
• Ability to identify, analyze, and resolve data discrepancies.
• Good understanding of data validation and reporting controls.

Preferred / Additional Skills :

• Basic knowledge of Macros / VBA.
• Experience with Tally ERP 9 or similar accounting/ERP tools.
• Basic understanding of accounting principles and financial transactions.
• Exposure to reporting automation and process improvement.
• Experience working with large volumes of financial or transactional data.
• Good analytical and problem-solving skills.
• Strong communication and stakeholder coordination skills.

Educational Qualification :

Minimum Qualification :

• Bachelor's degree in B.A. / B.Com or equivalent.

Preferred Qualification :

• B.Com
• B.A.
• MBA – Finance / Accounting

Ideal Candidate Profile :

The ideal candidate should have strong hands-on experience in MIS reporting, reconciliation, Excel-based data analysis, and management reporting, preferably within the Fintech, BFSI, financial services, payments, or transaction-driven environment.

The candidate should be highly detail-oriented, comfortable working with large datasets, capable of independently identifying discrepancies, and proactive in improving reporting and reconciliation processes.

Key Responsibilities

• Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
• Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
• Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
• Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
• Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
• Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
• Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
• Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.
• Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.

Required Skills & Qualifications

• Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.

• Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
• Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
• Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
• Good communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
• Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.

Job Title: Senior Data Analyst

Location: Sharnam Metrolinks, Amraiwadi, Ahmedabad

Working Days: 6 Days a Week

Department: MDO

Reporting To: COO

Employment Type: Full-Time

Job Summary

We are seeking a highly analytical and detail-oriented Senior Data Analyst to lead data management, reporting, automation, and system development initiatives across the organization.

The role focuses on transforming raw data into meaningful insights, designing and implementing automated systems, strengthening data structures, and supporting cross-functional teams with accurate, actionable intelligence to drive strategic and operational business decisions.

Key Responsibilities

1. Data Management & Reporting

● Collect, clean, validate, and consolidate data from multiple internal and external sources.

● Prepare and deliver daily, weekly, and monthly MIS reports for management and departments.

● Design, develop, and maintain dashboards to track KPIs, performance metrics, and operational trends.

2. Database & Data Accuracy Management

● Manage and regularly update internal databases, spreadsheets, and reporting systems.

● Ensure data accuracy, consistency, integrity, and confidentiality across all platforms.

● Implement best practices for data validation, version control, and audit checks.

3. Data Analysis & Business Insights

● Analyze large and complex datasets to identify trends, patterns, gaps, and anomalies.

● Translate data findings into clear, actionable insights and recommendations to support

strategic and operational decision-making.

4. Reporting Automation, System Recommendation & Implementation

● Identify opportunities to replace manual or semi-manual processes with automated, data-driven systems.

● Design and implement automated reporting frameworks, dashboards, and data pipelines using Excel (Power Query, VBA, Macros), SQL, BI tools, and Python.

● Proactively suggest new automation tools, system enhancements, or integrations to

improve efficiency, accuracy, and scalability.

● Lead the end-to-end implementation of approved automation initiatives, including requirement gathering, system design, testing, deployment, and stabilization.

● Continuously monitor and optimize automated systems in line with business growth and evolving data needs.

5. Cross-Functional Coordination & Support

● Collaborate with Sales, HR, Finance, Operations, and other departments to understand

reporting and data requirements.

● Provide support for ad-hoc analysis, custom reports, and special data requests.

● Act as a data partner to department heads for decision support and performance tracking.

6. Documentation & Compliance

● Maintain complete and updated documentation for MIS processes, reports, data models,

automation logic, and system changes.

● Ensure compliance with company data governance policies and applicable data protection standards.

System Development & Data Structuring Responsibilities

● Study and understand departmental workflows to evaluate how data is generated, processed, and utilized.

● Review existing manual and digital data systems to identify operational gaps, risks, and

mprovement opportunities.

● Recommend structured data models, reporting formats, and storage solutions aligned with

business requirements.

● Coordinate with department heads to define data structures, access levels, and reporting

standards.

● Implement new or upgraded data systems (Excel-based models, cloud platforms, ERP

integrations) with minimal operational disruption.

● Design structured data formats and role-based access controls to ensure secure and

organized data management.

● Train employees on newly implemented systems and provide post-implementation

support.

● Monitor system performance, resolve issues, and continuously improve systems based on

user feedback and organizational growth.

Qualifications & Experience

● Bachelor’s degree in Commerce, Statistics, Computer Applications, or a related field.

● 3–5 years of experience in data analytics, reporting, or system automation roles.

● Strong analytical thinking, logical reasoning, and problem-solving abilities.

● High attention to detail with excellent organizational and documentation skills.

Technical Skills (Must Have)

● Advanced Excel: Power Query, Power Pivot, VBA basics, Macros, Charts

● BI Tools: Power BI or Tableau (DAX, data modeling, dashboard optimization)

● Google Apps Script: Automation in Google Sheets, custom functions, triggers, API integrations, workflow optimization

● Vlook

Preferred Skills

● Strong verbal and written communication skills

● Ability to handle sensitive and confidential information responsibly

● Quick learner with a tech-savvy, improvement-driven, and solution-oriented mindset

Location-Mumbai-Vileparle

Working Days/Time – 6 days /10 AM -7 PM

Key Responsibilities

• Prepare and maintain daily, weekly, and monthly MIS reports
• Collect and validate data from multiple departments (Sales, Operations, Finance)
• Analyze data and highlight key trends, variances, and insights
• Develop and maintain dashboards using Excel or BI tools
• Ensure accuracy and consistency of data across reports
• Automate repetitive reports using advanced Excel or macros
• Support management with ad-hoc reports and analysis
• Coordinate with stakeholders to resolve data discrepancies
• Maintain proper documentation of reports and processes

Required Skills

• Strong knowledge of Microsoft Excel (Advanced Level)
• (Pivot Tables, XLOOKUP/VLOOKUP, IF, INDEX-MATCH)
• Good analytical and problem-solving skills
• High attention to detail and accuracy
• Ability to handle large datasets

Qualifications

• Bachelor’s degree (B.Com / BBA / BSc IT / similar)
• 1–2 years of experience in MIS / Reporting / Data handling roles 

Job Title: MIS Operations Executive

Location: Mumbai, Maharashtra

Industry: Insurance

Experience Required: 1 -5 Years

Job Summary:

We are seeking a detail-oriented and analytical MIS Operations Executive to support data management, reporting, and operational efficiency within our insurance business. The ideal candidate will be responsible for generating accurate reports, maintaining databases, and assisting in decision-making through data insights.

Key Responsibilities:

• Prepare daily, weekly, and monthly MIS reports related to sales, operations, and performance metrics
• Collect, analyze, and validate data from multiple sources to ensure accuracy and consistency
• Maintain and update databases, dashboards, and reporting systems
• Support business teams with ad hoc data requests and analysis
• Identify trends, discrepancies, and areas for improvement in operational processes
• Ensure timely submission of reports to management
• Coordinate with cross-functional teams (sales, underwriting, claims) for data requirements
• Assist in automation of reports using Excel or MIS tools

Key Skills Required:

• Strong proficiency in MS Excel (Pivot Tables, VLOOKUP, formulas)
• Basic knowledge of MIS reporting and data analysis
• Good analytical and problem-solving skills
• Attention to detail and accuracy
• Ability to manage deadlines and multitask
• Good communication and coordination skills

Preferred Qualifications:

• Bachelor’s degree in Commerce, Business Administration, or related field
• Familiarity with insurance processes (policies, claims, underwriting) is a plus
• Knowledge of tools like Power BI, SQL, or advanced Excel will be an advantage

Salary: As per industry standards

Working Hours: Full-time

Career Growth: Opportunity to grow into senior MIS roles, data analytics, or operations management within the insurance domain

Job Title: Data Entry Operator / Data Entry Clerk

Location-Hyderbad

5 Days working

Job Summary:

Company is seeking a talented and motivated Data Entry Operator who is

responsible for accurately entering, updating, and maintaining data in company databases and

systems. This role ensures information is recorded efficiently, securely, and with attention to detail

to support smooth business operations

Job Responsibilities:

• Enter and update data into databases, spreadsheets, and systems with high accuracy.

• Verify and correct data to ensure consistency and eliminate errors.

• Review source documents for completeness and clarity before entry.

• Maintain records of activities and completed work.

• Retrieve, organize, and present data for internal reports as required.

• Identify and report discrepancies or data quality issues to supervisors.

Requirements:

• High school diploma or equivalent

• Proven experience in data entry, clerical, or administrative work.

• Strong typing skills with accuracy and speed.

• Proficiency with MS Office (Excel, Word) and database software.

• Good time management skills.

• Strong attention to detail.

• Ability to work independently and meet deadlines.

We’re Hiring: Data Entry Operator / Data Entry Clerk

🏢 Location: Hyderabad

5 days working, Work from Office

💻 Role: Data accuracy, updates & record maintenance

✨ Responsibilities:

• 🧾 Enter & update data in systems with precision
• 🔍 Verify, correct & ensure data consistency
• 📂 Review source docs before entry
• 📊 Maintain and organize records & reports
• ⚠️ Identify and report data issues

🎯 Requirements:

• 🎓 Graduate
• 💼 Experience in data entry / admin work
• ⌨️ Fast & accurate typing
• 💻 Proficient in MS Excel & Word
• 🕒 Strong time management & detail-oriented
• 🚀 Able to work independently

📧 Apply Now

Requirements:

• Proven experience as an HRBP, preferably in large-scale, fast-paced environments.
• Awareness of key HR metrics like attrition, shrinkage, WFM, etc.
• Strong experience in event management, including planning and executing large-scale events.
• Ability to use technology and digital media to enhance communication effectiveness.
• Proficiency in Microsoft Office tools (Publisher, Word, Excel, PowerPoint, SharePoint, Live Meeting).
• High energy, drive, enthusiasm, initiative, and commitment.
• Excellent communication, influencing, and interpersonal skills with an approachable style.
• Strong judgment, patience, and tact in challenging situations.
• Willingness to work night shifts.

Mandatory Criteria (Can't be neglected during screening) :

• Candidate must have minimum 10 years of experience in Human Resource Management as a DM or Manager, including team management experience and fluent communication skills.
• Candidate must have handled at least 1300 employee headcount.
• Candidate must be at Manager or Deputy Manager level currently (Assistant Manager designation will not be considered).
• Need candidates from BPO, KPO, or BPM industry only.
• Candidate must have strong expertise in Excel (Pivot, VLOOKUP, formulas, MIS reporting etc.)
• Candidate must be comfortable working in evening/UK shifts (5:30 PM – 3:00 AM).
• Candidate should have experience in HR Operations, Recruitment, Payroll, Compliance and conducting new joiner orientations.

Job Title: CRM Executive

Location: Thane (Majiwada)

Age Requirement: Up to 30 Years

Experience: 1–2 years (Pharma industry – Cardio-Diabetic segment preferred)

Responsibilities:

• Manage and maintain customer databases, ensuring accuracy and completeness.
• Coordinate with sales and marketing teams to support CRM activities.
• Generate and analyze reports using MS Excel (Pivot, VLOOKUP, etc.).
• Ensure timely communication with clients and internal teams.
• Support day-to-day CRM operations to drive efficiency and client satisfaction.

Key Skills:

• Strong communication & coordination skills.
• Proficiency in MS Excel and data management.
• Pharma experience in Cardio-Diabetic segment is mandatory.

Note: This is a top priority position – immediate joiners will be preferred.

Job Title:

Data Entry Executive

Experience:

0–1 Year

Location:

Bangalore (Work from Office)

Employment Type:

Full-Time

About the Role:

We are looking for a detail-oriented and motivated Data Entry Executive to join our team. The ideal candidate should have a strong command of Microsoft Excel and Google Sheets, with the ability to efficiently manage, organize, and process data. This role is perfect for recent graduates or individuals with up to one year of experience who are looking to build a career in data management and digital operations.

Key Responsibilities:

• Accurately enter, update, and maintain data in Excel and Google Sheets.
• Utilize spreadsheet functions such as formulas, filtering, merging, dropdowns, and color filters.
• Apply and troubleshoot formulas like CONCAT, PROPER, LOWER, UPPER, and VLOOKUP.
• Organize and clean data to ensure accuracy and consistency.
• Generate reports and summaries as needed.
• Assist with basic SEO tasks such as keyword entry and metadata updates.
• Support content management on CMS platforms like Webflow and WordPress (preferred).
• Collaborate with team members to ensure timely completion of data-related tasks.
• Perform other administrative and data entry duties as assigned.

Required Skills:

• Strong proficiency in Excel and Google Sheets.
• Hands-on experience with formulas, sorting, filtering, merging, dropdowns, and formatting.
• Familiarity with functions like VLOOKUP, CONCAT, PROPER, LOWER, and UPPER.
• High attention to detail and accuracy.
• Basic understanding of SEO concepts.
• Good communication and organizational skills.
• Ability to work independently and collaboratively in a team environment.

Added Advantages (Preferred, not Mandatory):

• Experience working on CMS platforms like Webflow and WordPress.
• Basic knowledge of design tools such as Canva or Figma.

Qualifications:

• Bachelor's degree in any discipline (preferred).
• 0–1 year of relevant experience in data entry or a similar role.

Why Join Us?

• Be part of a dynamic and supportive team.
• Gain hands-on experience with industry-standard tools and platforms.
• Opportunity for growth and continuous skill development.

As a Back Office Executive, your primary responsibility is to gather, analyze, and interpret data to provide actionable insights that support decision-making processes within the organization. You will work closely with various teams to understand their research needs, contribute to strategic planning, and help enhance overall business performance.

Qualifications

1. Bachelor's or Master's degree.
2. Strong knowledge of Microsoft Office tools i.e. Microsoft Excel and Microsoft Word.
3. Excellent communication skills, both written and verbal.
4. Good knowledge of Google Spreadsheets, shortcut keys, and formulas.
5. Ability to work collaboratively in a team environment.
6. Prompt in web search.

We strongly prefer local candidates for this position as it is based in Ujjain.

Prepare daily attendance for all site and mail to corporate office.

Prepare Daily Call Report for all site and mail to corporate office.

Engineer shift roster has to make based on call

MS Office Knowledge

Pivot Tabel

Vlook up

Female Only

• Location: Vatva GIDC
• Experience : 1yr to 2yr (Only Male)
• Education: B.com or M.com

Desired Candidate Profile