The new XLOOKUP function is better, easier and faster than VLOOKUP, HLOOKUP, INDEX & MATCH and , and you also don't need IFERROR to hide errors because it's built in. 👩‍🏫 Master Excel with my courses: ⬇️ Download the example file here and follow along: LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: 🎯 FOLLOW me on LinkedIn: 💬 EXCEL QUESTIONS: Get help on our 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