• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

XLOOKUP in Excel

September 14, 2021 by Andrew Childress
How to use Xlookup in Excel

You might be familiar with Excel’s VLOOKUP feature to find specific values and reference columns in a table array. Here's how to use XLOOKUP in Excel.

You might be familiar with Excel’s VLOOKUP feature to find specific values and reference columns in a table array. But thanks to the newer XLOOKUP function, you now have access to greater versatility. Imagine, for example, that you need to look up one value, but return two other values. VLOOKUP won’t do this, but XLOOKUP makes it easy. Let’s learn how to use XLOOKUP in Microsoft Excel.

How to Use XLOOKUP in Microsoft Excel

Imagine a list of data, containing email addresses, names, and more. The email addresses are on the right, and names are on the left. You want to look up an email address and have Excel return both the first and last name of its owner. This won’t work in VLOOKUP, for two reasons: VLOOKUP searches only to the right, and it won’t return multiple variables.

This is the perfect time to use XLOOKUP. With your data formatted like this, click into cell H6. As you can see, the email address input is in cell G6. Excel will look up this value, and return the corresponding name in cell H6 and I6.

In cell H6, type =XLOOKUP( to open your formula. Excel will first ask for the lookup value, which is found in cell G6. Click G6, then add a comma:

=XLOOKUP(G6,

Xlookup in Excel

Now, Excel needs the range in the data containing the email addresses. Click and drag to select C2:C14:

=XLOOKUP(G6,C2:C14,

Finally, you’ll need the return array – the columns containing the data you want returned. Here, the return array is A2:B14. Close the parentheses, completing your formula as follows:

=XLOOKUP(G6,C2:C14,A2:B14)

How to use Xlookup in Excel

Hit Enter, and Excel will return the first and last name associated with the email address in cell G6.

Use Xlookup in Microsoft Excel

As you can see, XLOOKUP is a fast, versatile way to work with data in Microsoft Excel. Try it next time you need to perform complex lookups to return values quickly.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Sumproduct ExcelSUMPRODUCT in Excel
Next Post:Workbook Statistics in ExcelWorkbook statistics Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top