Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Excel Formulas & Functions Part 5: Lookup & Reference Functions

1. Introduction To Lookup & Reference Functions
2. Working with Named Arrays
3. ROW/ROWS & COLUMN/COLUMNS
4. VLOOKUP/HLOOKUP
5. Joining Data with VLOOKUP
6. Fixing Errors with IFERROR & VLOOKUP
7. VLOOKUP Reference Array Options
8. The INDEX Function
9. The MATCH Function
10. Using INDEX & MATCH Together
11. Combining MATCH with VLOOKUP
12. UPDATE: VLOOKUP Correction
13. The OFFSET Function
14. Combining OFFSET with COUNTA
15. PROJECT SHOWCASE: Using OFFSET to Create a Dynamic Scrolling Chart
16. HOMEWORK: Lookup/Reference Functions