Basic XLOOKUP example

Abstract

In this video, well set up theXLOOKUP functionwith a basic example.

The XLOOKUP function is a more flexible replacement forVLOOKUP, and it’s just as easy to use.

In this worksheet, we have population data for some of the largest cities in the world.

This is enough to match XLOOKUP.

I’ll then press the Tab key to confirm.

The first argument for XLOOKUP is thelookup_value.For this, we want to use the city name in G4.

The next argument islookup_array.

This is the range that contains the value we want to look up.

Next, we need to provide a range forreturn_array.

This is the range that contains the value we want to retrieve.

In this case, that’s the country names in C5:C18.

XLOOKUP only requires these 3 arguments.

If I like, I can provide a message to display when XLOOKUP finds no match.

Here I’ll use “No match” in double quotes.

XLOOKUP automatically performs an exact match, and automatically starts at the top of the data.

These defaults work just fine for this example, so we don’t need to set values formatch_modeorsearch_mode.

When I enter the formula, the result is Germany, which is correct.

Instead of Country, I want Population, which is D5:D18.