What the function - XLOOKUP for Excel in simple words

Опубликовано: 27 Декабрь 2024
на канале: Chandoo

20,855

572

Welcome to what the function - a new series of no nonsense guides on Excel functions.

In the first instalment, let's look at XLOOKUP, the VLOOKUP killer.

Use XLOOKUP to find matching data from your tables or ranges. The syntax for XLOOKUP is,
=XLOOKUP(what you want to lookup, lookup range, result range, optional if error value)

XLOOKUP will return EXACT match by default.

For more information on XLOOKUP, please see this page -

https://chandoo.org/wp/xlookup-examples/

#xlookup #WhatIsXlookup #VlookupAlternative