Skip to content

Left Lookup in Google Sheets

In this article, I will show you how to perform a left lookup in Google Sheets using the XLOOKUP function.

What is a Left Lookup?

Take the following data.

We have employees, their roles, and the regions they belong to.

An example of a left lookup would be to look up the employee by searching for a specific role or region. The employee names (possible result values) sit to the left of the roles and regions (possible lookup values).

So a specific example of a left lookup would be to get back the name of the employee assigned to the South region.

How to Perform a Left Lookup

The XLOOKUP function is the easiest function to use to perform a left lookup in Google Sheets.

Let’s look at the following example.

The goal is to return the employee assigned to the South region.

You enter the XLOOKUP function and select the lookup value (region) for the first argument.

=XLOOKUP(C2

Then for the second argument, you select the range of lookup values (regions). It does not matter if the lookup values are to the left or right of the result values.

=XLOOKUP(C2, D6:D9

For the third argument, you select the range of result values. Again, it doesn’t matter if the result values are to the left or right of the lookup values.

=XLOOKUP(C2, D6:D9, B6:B9)

As a result, you get back the employee assigned to the South region.

And that is how to perform a left lookup in Google Sheets.

This Post Has One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top