Advanced Module 03
LOOKUP Functions

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.

Download the training notes (PDF)

3.1    Training Notes

3.2   VLOOKUP

3.3   VLOOKUP exercise - solutions

3.4   HLOOKUP

3.5   HLOOKUP exercise - solutions

3.6   LOOKUP

3.7   MATCH and INDEX

3.8   MATCH and INDEX exercise - solutions


Privacy Terms Contact
Copyright © Two Rivers Software Training. All Rights Reserved