Create an account to use AI

Create a free account to unlock all features:

Ask questions about videos with AI
Use smart search (AI)
Save your favorite videos
Bookmark your favorite categories
Organize your favorite subcategories
Access your personalized favorites page
Access your conversation history
Personalize your homepage with your favorites

Create an account

Already have an account? Log in

XLOOKUP Complete Tutorial in Excel (+ Hidden Tricks)

MyOnlineTrainingHub

The new XLOOKUP function is better, easier and faster than VLOOKUP, HLOOKUP, INDEX & MATCH and OFFSET...oh, and you also don't need IFERROR to hide errors because it's built in.

👩‍🏫 Master Excel with my courses: https://bit.ly/xlookup20courses

⬇️ Download the example file here and follow along: https://bit.ly/xlookup20file

LEARN MORE

===========

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up

🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum

⏲ TIMESTAMPS

==============

0:00 How to use the XLOOKUP Function

1:01 XLOOKUP syntax

1:37 Simple XLOOKUP

2:53 XLOOKUP does HLOOKUP

4:17 XLOOKUP does INDEX & MATCH

7:14 XLOOKUP Returns Multiple Columns

11:18 XLOOKUP Dynamic Range

13:37 XLOOKUP Error Handling

14:45 XLOOKUP Last Value

16:13 XLOOKUP Left

17:18 XLOOKUP Wildcards

18:25 XLOOKUP Approximate Match

#Excel #XLOOKUP #ExcelFunctions

XLOOKUP Complete Tutorial in Excel (+ Hidden Tricks) | Knoovi