XLOOKUP Complete Tutorial in Excel Hidden Tricks

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=2ViMm-wuM3U

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/e... • • 🎯 FOLLOW me on LinkedIn: / myndatreacy • 💬 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 • #Excel #XLOOKUP #ExcelFunctions

#############################

New on site