XLOOKUP Function in Excel – The Modern Replacement for VLOOKUP
Learn how XLOOKUP works, why it's better than VLOOKUP and how to use it with practical examples.
Xplore Excel
Learn Excel in easy way
India's Free Excel Learning Platform
Master Excel.
From Zero
to Expert.
Free formulas, shortcuts, templates and step-by-step tutorials — everything you need to become an Excel pro, at zero cost.
25+
Free Formulas
7+
Free Templates
3
Shortcut Levels
100%
Free Forever
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Month | Revenue | Target | Achieved % |
| 2 | January | ₹1,24,500 | ₹1,00,000 | 124.5% |
| 3 | February | ₹98,200 | ₹1,00,000 | 98.2% |
| 4 | March | ₹1,56,780 | ₹1,20,000 | 130.6% |
| 5 | Total | ₹3,79,480 | SUM ✓ |
💡 200+ formulas explained with free practice sheets
📥 Free Templates
Interactive Lesson Directory
Step-by-Step Excel Tutorial
Select your skill level below to explore all 40 structured lessons with detailed guides and practice sheets.
Beginner
Excel Basics & Formatting
Master the fundamentals of cells, formatting, and simple formulas
LESSON 1
Introduction to Excel
Navigate the Excel interface, Ribbon, worksheets, and workbook structures.
LESSON 2
Cells, Rows & Columns
Master grid navigation, row/column resizing, insertion, and selection tips.
LESSON 3
Entering & Editing Data
Input, edit, and delete numbers, text, dates, and clear formatting.
LESSON 4
Basic Formatting
Apply font styles, cell fills, borders, alignments, and the Format Painter.
LESSON 5
Save, Share & Formats
Explore XLSX, CSV, and PDF formats, file saving, auto-recover, and sharing.
LESSON 6
AutoFill & Flash Fill
Instantly populate lists, dates, and patterns, and perform data extraction.
LESSON 7
Basic Formulas
Perform basic math calculations with SUM, AVERAGE, COUNT, MAX, and MIN.
LESSON 8
Cell References
Understand the critical difference between relative, absolute ($), and mixed references.
LESSON 9
Named Ranges
Assign descriptive names to cells and arrays for cleaner, readable formulas.
LESSON 10
Sorting & Filtering
Organize tables alphabetically or numerically and filter for specific datasets.
LESSON 11
Basic Charts
Build visual column, bar, line, and pie charts from raw table data.
LESSON 12
Print & Page Setup
Configure margins, set print areas, scale fit pages, and print gridlines.
Intermediate
Functions & Data Tools
Level up your Excel skills with powerful functions and relational analysis
LESSON 13
IF & Logical Functions
Build decision logic with IF, AND, OR, NOT, and nested conditions.
LESSON 14
VLOOKUP & HLOOKUP
Look up data across tables with exact and approximate matching.
LESSON 15
INDEX & MATCH
The powerful VLOOKUP alternative for two-way lookups.
LESSON 16
Text Functions
Manipulate text with LEFT, RIGHT, MID, TRIM, CONCATENATE, and more.
LESSON 17
Date & Time Functions
Work with dates using TODAY, NOW, DATEDIF, and WORKDAY.
LESSON 18
COUNTIF / SUMIF / AVERAGEIF
Count, sum, and average data based on conditions.
LESSON 19
Pivot Tables
Summarize thousands of rows of data instantly with Pivot Tables.
LESSON 20
Conditional Formatting
Highlight cells automatically with rules, data bars, and color scales.
LESSON 21
Data Validation
Control what users can enter with dropdown lists and custom rules.
LESSON 22
Advanced Charts
Combo charts, sparklines, and dynamic chart techniques.
LESSON 23
Tables & References
Format data as Tables and use structured column references.
LESSON 24
Error Handling
Handle Excel errors gracefully with IFERROR, IFNA, and error types.
LESSON 25
Protect Sheets & Workbooks
Lock cells, password-protect sheets, and secure your workbooks.
LESSON 26
What-If Analysis
Use Goal Seek, Scenario Manager, and Data Tables for forecasting.
Advanced
Automation, VBA & Expert Tools
Build databases, automate workflows, and code custom functions with VBA
LESSON 27
XLOOKUP Function
Master the powerful, flexible successor to VLOOKUP for modern lookups.
LESSON 28
Dynamic Arrays
Build dynamic worksheets using FILTER, SORT, UNIQUE, and spill ranges.
LESSON 29
Power Query
Connect to, clean, transform, and merge external data automatically.
LESSON 30
Power Pivot & Data Models
Model relational databases and summarize millions of rows of datasets.
LESSON 31
Macros Recording
Record, manage, and play back actions to automate repetitive tasks.
LESSON 32
Introduction to VBA
Write your first sub-procedures and explore the Visual Basic Editor (VBE).
LESSON 33
VBA Loops & Conditions
Add logic and loop through tables using For loops and If-Then conditions.
LESSON 34
Advanced Pivot Tables
Utilize Calculated Fields, grouping options, and complex slicing.
LESSON 35
Array Formulas (CSE)
Understand legacy Ctrl + Shift + Enter array math and multi-cell formulas.
LESSON 36
Financial Functions
Compute PMT loan payments, Net Present Value (NPV), and IRR return rates.
LESSON 37
Statistical Functions
Analyze data with standard deviations (STDEV), percentiles, and multi-criteria counts.
LESSON 38
KPI Dashboards
Build dynamic, interactive dashboards using KPI charts, sparklines, and slicers.
LESSON 39
External Data Imports
Connect and pull live data into your spreadsheet from SQL, JSON, and Web URLs.
LESSON 40
Excel Best Practices
Master the formatting, planning, and structure habits that set professionals apart.
VLOOKUP · INDEX MATCH · SUMIF · Pivot Tables · COUNTIF · Conditional Formatting · HLOOKUP · Keyboard Shortcuts · IF / IFS / IFERROR · Free Templates · XLOOKUP · GST Invoice · TRIM & CLEAN · Gantt Chart · VLOOKUP · INDEX MATCH · SUMIF · Pivot Tables · COUNTIF · Conditional Formatting · HLOOKUP · Keyboard Shortcuts · IF / IFS / IFERROR · Free Templates · XLOOKUP · GST Invoice · TRIM & CLEAN · Gantt Chart ·
What We Offer
Everything to make you an Excel expert
From beginner formulas to advanced automation — structured, free learning that genuinely sticks.
POPULAR
Excel Formulas
Deep dives into 25+ formulas with real-world examples, downloadable practice workbooks and step-by-step walkthroughs.
Browse Formulas →Keyboard Shortcuts
Level-wise guides: Basic, Intermediate and Advanced. Learn the keystrokes that save you hours every single week.
View Shortcuts →
FREE
Excel Templates
Ready-to-use templates for GST invoices, cash books, income & expense trackers, savings planners and more.
Get Templates →VLOOKUP & HLOOKUP
Master the two most-used lookup formulas. Includes 5 free practice sheets for each so you learn by doing.
Learn VLOOKUP →XLOOKUP — The Future
The modern replacement for VLOOKUP. Flexible, powerful and much easier to write. Learn it with free examples.
Learn XLOOKUP →TRIM & CLEAN
Fix messy, inconsistent data in seconds. Two underrated functions that every Excel user absolutely needs to know.
Read Article →Learning Path
Your journey from beginner to Excel pro
A clear, four-step roadmap. Follow it in order, or jump straight to what you need right now.
Start Here
01
Excel Basics
Interface, cells, rows, columns, basic navigation and essential data entry fundamentals.
02
Core Formulas
SUM, AVERAGE, COUNT, IF, VLOOKUP — the formulas you'll use every single day at work.
03
Advanced Functions
INDEX MATCH, SUMIFS, XLOOKUP, TRIM/CLEAN, IFERROR, nested IFs and data validation.
Pro Level
04
Templates & Shortcuts
Download real-world templates, master keyboard shortcuts and automate your daily tasks.
Latest Posts
Fresh from the Tutorials, Formulas and Templates
New tutorials, formulas and templates added regularly. There's always something new to learn.
📊
Excel Formula
📅
Excel Template
Project Timeline Gantt Chart Template in Excel – Free Download
A fully dynamic Gantt chart template to plan and track your projects visually inside Excel.
🧹
Excel Formula
TRIM and CLEAN Functions in Excel – Fix Messy Data Easily
Two powerful but underrated functions that instantly clean unwanted spaces and characters from your data.
⌨️
Excel Shortcuts
Top 20 Excel Shortcuts for Data Entry
Speed up your data entry workflow with 20 time-saving shortcuts every Excel user should know.
❓
Excel Formula
IFNA Excel Function – Free 2 Practice Workbooks
Handle #N/A errors gracefully using the IFNA function, with two free downloadable practice sheets.
🚫
Excel Formula
IFERROR Excel Function – Free 2 Practice Workbooks
Stop formula errors from breaking your spreadsheets. Learn IFERROR with clear examples and practice files.
Free Downloads
Ready-to-use Excel templates
Download, customize and start using immediately — no sign-up required, completely free.
🧾
GST Invoice Format 3.1
Auto-calculates GST, CGST & SGST. Used by thousands of Indian businesses daily.
📋
GST Quotation Format 1.0
Professional GST-ready quotation template to send to clients instantly.
📒
Cash Book Template 1.2
Know your cash & bank balance on any date. Dynamic and easy to maintain.
💰
Income & Expenses Tracker 1.0
Understand your actual business profitability month by month with visual summaries.
🐷
Saving Tracker Template 1.0
Set savings goals and track your progress automatically, month by month.
📅
Project Timeline Gantt Chart
Plan and visualize your project timeline with this dynamic, fully free Gantt chart template.
🗂️
5 GST Invoice Templates
Five different invoice designs in both Excel and Google Sheets formats. Pick your favourite style.
Excel Shortcuts
Work faster with keyboard shortcuts
Three level-wise guides — from your very first day in Excel all the way to advanced power-user shortcuts.
Basic Shortcuts
10 must-know shortcuts for beginners. The ones you'll reach for every single day.
Ctrl+C
Ctrl+Z
Ctrl+S
Ctrl+F
F2
Learn Basic Shortcuts →
Intermediate Shortcuts
Level up with shortcuts that professionals use to speed through common spreadsheet tasks.
Ctrl+Shift+L
Alt+E+S
Ctrl+1
F4
Learn Intermediate →
Advanced Shortcuts
Power-user shortcuts that separate genuine Excel experts from everyone else at the office.
Ctrl+Shift+Enter
Alt+F8
Ctrl+`
Learn Advanced →
Start learning Excel today — 100% free, forever
Join thousands of learners across India who have levelled up their Excel skills, downloaded templates and boosted their career using XplorExcel.