How to use Excel Index Match (the right way)

How to use INDEX and MATCH in Excel: look up values in any direction, and build lookup formulas that don't break when columns move. 📥 Download the practice file: https://www.xelplus.com/excel-index-a... 🎓 500,000+ enrolled in our courses. Build interactive reports in the Excel Dashboards course 👉 https://www.xelplus.com/course/excel-... VLOOKUP only looks to the right. It can also return the wrong result when you insert or delete columns, because the column number is typed into the formula. INDEX and MATCH fix both problems. You'll see how INDEX returns a value from a position, how MATCH finds that position for you, and how to combine the two step by step. Then you'll build a two-way lookup that finds the value where a row and a column meet. Note: INDEX and MATCH are not case-sensitive. Version note: In Excel 365 and Excel 2021 or later, XLOOKUP can also look left and keeps working when columns move. INDEX and MATCH work in every Excel version, so they're still worth knowing. 00:00 The VLOOKUP Problem (Why Formulas Break) 01:44 How the INDEX Function Works 05:06 Use MATCH to Find the Row or Column Number 06:37 Combine INDEX and MATCH Step by Step 08:08 Two-Way Lookups with INDEX and MATCH ➡️ Join this channel to get access to perks:    / @leilagharani   ✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 🚩 Connect with us: Instagram:   / lgharani   LinkedIn:   / leilagharani   #excel #indexmatch #excelformulas