Advanced Lookups: Two-Way, Multi-Criteria and Tiers
All lessons
- Advanced Lookups: Two-Way, Multi-Criteria and TiersFree
- Multi-Criteria SUMIFS, COUNTIFS, AVERAGEIFS and MAXIFS Pro
- SUMPRODUCT with Boolean Arrays Pro
- Array Math inside SUM, AVERAGE, MAX and MATCH Pro
- Nested Logic: IFS, SWITCH, CHOOSE and IFERROR Pro
- Text Formulas: FIND, MID, SUBSTITUTE, TEXT and TEXTJOIN Pro
- Date & Time Formulas: EOMONTH, NETWORKDAYS, WEEKNUM, HOUR Pro
- Statistical Formulas: RANK, PERCENTRANK, LARGE and Conditional MEDIAN Pro
- Financial Formulas: PMT, PPMT, NPV and XNPV Pro
- Capstone: Audit and Repair a Broken Report Pro
You are not signed in — the lab works, but your progress is not saved. Start free
Loading the spreadsheet…