XLOOKUP Horizontal Lookup

Learn to perform a horizontal lookup using XLOOKUP. With XLOOKUP, you no longer have to use the very limited HLOOKUP function. In the example below, we will perform a lookup with an Exact match and an Approximate Match.

Let’s take a look at the following example. Here, we are using a horizontal lookup to return the batting average of a particular player.

XLOOKUP Horizontal Lookup
XLOOKUP Horizontal Lookup
=XLOOKUP(value,range1,range2) // exact match

=XLOOKUP(value,range1,range2,,-1) // approximate match

As a reminder, an Exact match is a returned result that matches 100% the value being requested. For example, if you want to find “Bob,” Excel will find “Bob.”

For an Approximate match, Excel will find a close, but not Exact result. In the example above, if a name is missing a letter, “Joh, ” Excel will still match “John.” In the formula, we add “-1.”

Click here for a complete understanding of the XLOOKUP Function.

Leave a Reply

What is a Macro?

Macro is just the name given to the codes written in VBA. So our codes, henceforth, will be referred to

Read More »

Average Function

AVERAGE (Arithmetic Mean) Finding the arithmetic mean in Excel is very easy. Just like in basic math, you add up

Read More »
Scroll to Top