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

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

Horizontal lookup3:04
2-dimensional Lookup - Look up both a row and a column4:48
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
Numbers stored as text in Excel explained4:44
Dealing with "Numbers stored a text" problem in XLOOKUP6:36
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
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
Nested functions - combining VLOOKUP with other functions3:42
Case study: Comparing two pricelists using VLOOKUP4:18

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: