Learn XLOOKUP in 14 easy examples

Name: Learn XLOOKUP in 14 easy examples
Rating: 4.7 (31 reviews)

Learn Excel, get a higher salary and lower less stress level at work

Created byJiri Benedikt

Last updated 4/2020

English

English [Auto],

What you'll learn

Microsoft Excel
XLOOKUP
VLOOKUP
Excel Functions
Working with data

Course content

5 sections • 28 lectures • 1h 51m total length

Introduction0:52
Explore the xlookup function in 14 easy examples through practical, self-contained lessons with downloadable sample data for office 365 users to simplify tasks and bring happier days at work.
What is XLOOKUP? Do I have it?0:56
Before you start: Language and regional differences in Excel3:29
Learn how language versions affect excel formulas and interfaces, including translated function names and decimal separators, and compare excel and google sheets behavior, with a focus on xlookup differences.

XLOOKUP intro for beginners1:54
This class contains an Excel workbook for all the XLOOKUP examples in this course. Download it and practice with me!
Differences between VLOOKUP and XLOOKUP2:16
Explore differences between vlookup and xlookup, including how xlookup searches left, handles search and results columns, and avoids column counting; learn about exact versus approximate match and default behaviors.
Avoiding traps in XLOOKUP4:31
Learn to avoid traps in XLOOKUP by using absolute references and full-column ranges so formulas adapt automatically, and ensure exact matches to prevent extra spaces from breaking results.
Looking up multiple columns at once with XLOOKUP2:19
Custom error message (#N/A) with XLOOKUP2:25
Looking up from a table on another sheet5:28
Learn how to use xlookup across different sheets to pull trip names and prices from a separate price sheet, with practical tips on referencing, switching sheets, and avoiding common mistakes.

Horizontal lookup3:04
Use XLOOKUP for horizontal search by locating a country in a row and returning the corresponding total; apply absolute references (F4) to keep inputs fixed.
2-dimensional Lookup - Look up both a row and a column4:48
Master two-dimensional lookup in Excel by using XLOOKUP to match both a country column and a sales representative row, leveraging dynamic arrays and spill behavior to retrieve the correct cell.
Wildcard search - Lookup a value when you only have a part of it7:48
Learn wildcard lookups with XLOOKUP in Excel, using * and ? to find partial names, concatenate with &, and retrieve full names plus IDs, with top-down or bottom-up search.
Approximate match with XLOOKUP3:26
Explore xlookup approximate matches to map customer sales to rebate thresholds across two tables, using exact, next smaller, or next larger matches, and calculate the absolute rebate.
Numbers stored as text in Excel explained4:44
Explore why lookups misfire when IDs are stored as text in Excel, and learn how to set cells to text, distinguish text vs numbers, and convert between them.
Dealing with "Numbers stored a text" problem in XLOOKUP6:36
Learn to fix numbers stored as text in XLOOKUP by converting with TEXT, or using paste special to coerce to numbers, and verify data types with ISTEXT.
Nested Functions3:34

VLOOKUP intro for beginners4:32
This class contains an Excel workbook for all the VLOOKUP examples that you get for free with this course. Download it and practice with me!
Looking up from a table on another sheet4:07
Learn how to use xlookup to fetch trip names and prices from a price list on another sheet, handling exact match, range lookup, and column index across multiple sheets.
Common VLOOKUP errors and mistake and how to avoid them5:52
VLOOKUP Tips and tricks3:22
Identify and fix vlookup issues by removing trailing spaces, ensure exact matches, and choose between exact or approximate lookup for reliable results.
Numbers stored as text in Excel explained4:02
learn how to use xlookup to fill customer names into orders and troubleshoot text versus number data in excel, including keeping leading zeros and plus signs.
Dealing with "Numbers stored a text" problem in VLOOKUP8:24
Resolve vlookup errors when IDs are stored as text by converting the numbers to text or to numbers, using the text function and paste special multiply techniques.
Error handling with IFERROR3:03
Approximate match with VLOOKUP2:45
VLOOKUP from multiple source tables3:57
Discover how to perform lookups from multiple price lists in Excel using vlookup with iferror, nesting to pull a trip name from the first or second list.
Nested functions - combining VLOOKUP with other functions3:42
Case study: Comparing two pricelists using VLOOKUP4:18
Compare two price lists across sheets using vlookup to reveal last-year prices, price differences, and discontinued or new items.

Requirements

Understand very basic formulas in Excel, such ass SUM or Average
Have Microsoft Office 365

Description

My name is Jiri, I am an excel trainer and this is my class on the XLOOKUP function. If you have Office 365, you already have access to this new amazing function that is here to replace VLOOKUP. If you master it, your life will be so much easier! It does not matter if you used VLOOKUP before, this class is for you.

This training has 14 videos with easy examples + additional free 14 examples on VLOOKUP. Each video is a self contained lesson If you want to follow what I am doing, please download the worksheet with the sample data I am using.

I hope you will enjoy this class. I also believe and this knowledge of Excel will bring you better job or easier and happier days at work.

Who this course is for:

Microsoft Office 365 Users wanting to learn the new XLOOKUP function
Both VLOOKUP users and VLOOKUP Novices
Microsoft Excel Intermediate and Advanced users
People working with data in Admin, Operations, Finance, Accounting, Warehousing, Master data and many more

Learn XLOOKUP in 14 easy examples

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 5min

XLOOKUP introduction6 lectures • 19min

XLOOKUP advanced7 lectures • 34min

Case study1 lecture • 5min

BONUS: Free VLOOKUP curse11 lectures • 48min

Requirements

Description

Who this course is for: