Free courses from frontend to fullstack and AI
Master Production-Ready Machine Learning, Step by Step
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This tutorial teaches XLOOKUP in Excel by first reviewing VLOOKUP and INDEX/MATCH, then demonstrating approximate matches, multiple returned values, and two-way searches. It includes hands-on spreadsheet exercises and is intended for Excel users, especially those using Office 365.
Syllabus
Start
Introduction
Introduction to VLOOKUP
VLOOKUP Limitations
Introduction to Index and Match
Introduction to XLOOKUP
XLOOKUP - Approximate Match
XLOOKUP - Multiple Values Returned
XLOOKUP - Two Way Search
Conclusion
Taught by
Learnit Training