Lookup & Reference
What you will be able to do
- Look up values with VLOOKUP, INDEX and MATCH
- Use XLOOKUP and XMATCH
- Build two-way and multi-condition lookups
- Map a trial balance to the financial statements
17 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Classic lookups
- VLOOKUP: exact match
- VLOOKUP: approximate match
- HLOOKUP
- INDEX
- MATCH
- INDEX + MATCH together
Module 2: Modern lookups
- XLOOKUP basics
- XLOOKUP options
- XLOOKUP returning several columns
- XMATCH
- Two-way lookups
- Lookups with several conditions
Module 3: Flexible references
- CHOOSE
- INDIRECT
- OFFSET
- Avoiding fragile formulas
Project: map a trial balance to the financial statements
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free