Choosing the Right Lookup Approach

Excel provides multiple lookup functions. They exist because lookup problems differ in structure and complexity. Before learning individual functions, it is important to understand how they differ.

There are three main lookup categories.

Lookup Categories Overview

The correct lookup function depends on:

• The structure of the data;
• The number of expected results;
• Excel version compatibility;
• The need for flexibility.

You do not choose the function randomly. You choose it based on the problem structure. Here, we discuss why certain functions exist. In the following section, you will inspect how each function works in practice.