How to Use XLOOKUP in Excel

Показать описание

The XLOOKUP function in Excel is being hailed as the replacement for both VLOOKUP and HLOOKUP, hence the “X” standing in for either character.

Like its predecessors, XLOOKUP looks for a value in a table and returns a matching result.

But whereas the other lookup functions require complex pairing with other functions like INDEX/MATCH to search in different areas, or IFERROR to display a customized message, XLOOKUP comes with those functionalities built in.

And who wants to type two formulas instead of just one?

In this video, we’ll discuss XLOOKUP and how to use it like a pro!

Skip to:
0:00 - What is XLOOKUP

0:18 - How can you use XLOOKUP?
4:07 - Returning multiple values
6:47 - Optional Arguments
7:04 - If_not_found
8:37 - Match mode
11:53 - Search mode
14:34 - Conclusion

——

——

#XLOOKUP #MSExcel #ExcelTutorial

——

——

For more updates follow us on:

——
Created and presented by Claudia Buckley