Course Notes
In this episode of Microsoft Excel, Season 2, we focus on "Section 4: How to Use VLOOKUP, MATCH & INDEX in Excel | Step-by-Step Guide". Watch the full video above, then use these notes to review the key ideas and put them into practice.
- Understand the core concept introduced in "Section 4: How to Use VLOOKUP, MATCH & INDEX in Excel | Step-by-Step Guide" and why it matters in Microsoft Excel.
- Follow along with the walkthrough — pause and replicate each step on your own.
- Connect this lesson with what you learned in the previous episode of Season 2.
- Note down one question you still have; it will often be answered in the next episode.
Practice task: spend 15 minutes applying "Section 4: How to Use VLOOKUP, MATCH & INDEX in Excel | Step-by-Step Guide" to a small project of your own before moving to Episode 6.