Excel Genius Class 6: VLOOKUP and INDEX/MATCH

Description:

This class will cover different kinds of functions used to search for information in a database, and work with the results. Topics include VLOOKUP, INDEX MATCH, & INDEX MATCH MATCH.

Skills required:

• Be able to write functions

• Understand Absolute vs Relative Cell References

• Know how to write structured references a plus

Prerequisites:

Beginner and Intermediate Excel, Excel Genius Class 5

Class Handout: