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.

DOWNLOAD EXCEL FILE INCL. STEP BY STEP WRITTEN INSTRUCTIONS: https://www.myonlinetraininghub.com/e...

LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/

SUBSCRIBE if you’d like more tips and tutorials like this.

Please leave me a COMMENT. I read them all!

‍♀ CONNECT with Mynda on LinkedIn:   / myndatreacy  

SHARE this video and spread the Excel love.

Or if you’re short of time, please click the

EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...

⏲ 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