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
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.