Course Title: VLOOKUP / HLOOKUP / INDEX / MATCH

Course Description



Unlock the power of Excel’s most useful lookup functions in this focused, hands-on class.



In this session, you’ll learn how to use VLOOKUP and HLOOKUP to quickly find and match data across your spreadsheets—whether your information runs vertically or horizontally. You’ll also master related functions like INDEX, MATCH, and LOOKUP, giving you a complete toolkit for analyzing and organizing data efficiently.

You’ll explore the difference between exact matches (FALSE) and approximate matches (TRUE) within VLOOKUP and HLOOKUP, and see real-world examples of how each is used to return correct and dynamic results. Additionally, you’ll learn how to build an Age Lookup formula that calculates ages or ranges instantly—ideal for HR, sales, and data management applications.

By the end of the course, you’ll be able to combine lookup functions to create powerful, flexible formulas that save time and reduce errors. Whether you’re an Excel beginner looking to level up your skills or an experienced user ready to fine-tune your data analysis, this class will help you confidently navigate and automate complex lookup tasks in Microsoft Excel.