Data Analysis with Excel 📈📉📊✅ - STOP using INDEX MATCH in Excel, use this instead!!!

Excel's INDEX+MATCH formula is a staple for many. But do you know that Excel now has a simple alternative to this powerful formula combination? Yes, I haven't used INDEX MATCH function in over a year and here is why. 👉 XLOOKUP 👈 The magic new function can do what INDEX+MATCH does with a simpler syntax and offers many extra features. In this video, I will show you how you can replace your messy INDEX+MATCH formulas with simpler XLOOKUP variation. Timestamps: =========== 0:00 - Introduction 0:09 - XLOOKUP overview & demo 1:10 - INDEX MATCH replacement with XLOOKUP 2:54 - Dealing with errors & If not found option in XLOOKUP 3:40 - One more example of XLOOKUP 4:09 - Advanced use of XLOOKUP - showing all details for matching values 5:35 - Closing remarks Example file + more on XLOOKUP: =========================== https://chandoo.org/wp/xlookup-examples/ 👉Checkout my online course on Advanced Excel & Data analysis =================================================== 💻📗💥 https://chandoo.org/wp/excel-school-program/ #XLOOKUP #ExcelTricks