XLOOKUP basics

1 / 6

We have emails in E2:E6 and want the matching names in F2:F6.

keyboard Typing formulas is easiest on a computer with a keyboard.

A1
ABCDEFG
1NameEmailTeamEmailName
2Tariq Litariq.li@example.comWestkofi.patel@example.com
3Nadia Patelnadia.patel@example.comWestsam.okafor@example.com
4Daniel Fischerdaniel.fischer@example.comNorthjamal.novak@example.com
5Quinn Evansquinn.evans@example.comWestrosa.jensen@example.com
6Jamal Novakjamal.novak@example.comNorthtariq.li@example.com
7Isla Kowalskiisla.kowalski@example.comSouth
8Kofi Patelkofi.patel@example.comSouth
9Yusuf Duboisyusuf.dubois@example.comNorth
10Sam Okaforsam.okafor@example.comNorth
11Rosa Jensenrosa.jensen@example.comEast
12
13
14
15
emails
names go here
Type to enter a value or a formula starting with =. F2 edits, F4 adds $ to a reference.
Study notes

How XLOOKUP works

  • What is XLOOKUP?

    XLOOKUP is the modern replacement for VLOOKUP. Instead of a table and a column number, you give it two columns: where to search and what to return.

    =XLOOKUP(lookup_value, lookup_array, return_array)

  • What are the two columns?

    • lookup_array: the column to search, e.g. B2:B11.
    • return_array: the column with the answers, e.g. A2:A11.

  • Why is it better than VLOOKUP?

    Because the two columns are separate, the answer can be to the left of the search column, something VLOOKUP can't do. XLOOKUP also matches exactly by default.

Know someone fighting with a spreadsheet? Send them this page.