Lookup Functions

Overview Schedule Dates Course Content Faqs

Course Overview

This two-day instructor-led course provides students with the knowledge and skills to write basic Excel lookup formulas as well as in-depth nesting of advanced array and reference functions. The purpose of the course is not only to show that certain functions exist and what they look like, but to show the diversity and usefulness of those functions. This is a very hands-on approach with constant examples, practices, and problem-solving provided to the audience.

Learning Outcomes

After completing this course, students will be able to:

List the LOOKUP function in Excel.
Recognize the opportunities for LOOKUP function use.
Decide which lookup function is best in the given scenario.
Always keep in mind a wide range of functions and can combine their use.

Learning Options

Online Instructor Led

Learn from the comforts of your home/office with our expert trainers via online platforms.

Classroom Training

Face-to-face physical classroom training with max interactions at our 5* training venues.

Onsite Training

Learn in your own environment from our expert trainers for maximum impact.

Overseas Training

Choose your desired country for learning with our expert trainers.

Target Audiance

The meticulous analyst, dissecting each function for its precision and efficiency.
The eager learner, absorbing every detail with wide-eyed enthusiasm.
The seasoned professional, refining their skills to optimize data manipulation.

Schedule Dates

28 October 2024 - 29 October 2024

Lookup Functions

28 January 2025 - 29 January 2025

Lookup Functions

28 April 2025 - 29 April 2025

Lookup Functions

28 July 2025 - 29 July 2025

Course Content

Example by using the IF function
Which LOOKUP functions are at our disposal
Other functions we will use during this course
What knowledge should we possess before moving on

LOOKUOP function
VLOOKUP function
HLOOKUP function

MATCH function
How can we use MATCH with VLOOKUP
INDEX function
Combining MATCH and INDEX functions
INDIRECT function
CHOOSE function
CELL function
OFFSET function
ROW and COLUMN functions

FAQs

Lookup functions are Excel formulas used to search for specific values within a dataset. They are vital because they allow users to efficiently retrieve information from large sets of data without manual searching, saving time and reducing errors.

Common lookup functions include VLOOKUP, HLOOKUP, INDEX-MATCH, and XLOOKUP. Each function has its own strengths and best-use scenarios, depending on the structure and requirements of the data.

VLOOKUP searches for a value vertically (down columns) in the leftmost column of a table and returns a value in the same row from a specified column. HLOOKUP, on the other hand, searches horizontally (across rows) in the top row of a table and returns a value in the same column from a specified row.

INDEX-MATCH is often preferred over VLOOKUP or HLOOKUP when dealing with large datasets or when the lookup value is not in the first column or row of the table. It offers more flexibility and can handle dynamic ranges more effectively.

VLOOKUP has limitations such as its inability to search to the left, limited flexibility in specifying the search criteria, and susceptibility to errors when the dataset changes. These limitations can be overcome by using INDEX-MATCH or XLOOKUP, which provide more robust and versatile lookup capabilities.