Visit Clubhouse Store
Advanced Module 03
Discover how to use powerful lookup functions like VLOOKUP, HLOOKUP, LOOKUP, MATCH and INDEX, both individually and in combination, to extract data from your table.
3.1 Training Notes
3.3 VLOOKUP exercise - solutions
3.5 HLOOKUP exercise - solutions
3.7 MATCH and INDEX
3.8 MATCH and INDEX exercise - solutions