Microsoft Excel 2021365 - Beginner to Advanced - Using XLOOKUP and XMATCH

The video introduces two new Excel 2021 functions, X LOOKUP and X MATCH, as alternatives to the traditional INDEX and MATCH functions. It explains the basic and advanced usage of X LOOKUP, including mandatory and optional arguments, and demonstrates how to use it with Excel tables. The video also covers the X MATCH function, highlighting its similarities to the MATCH function but with added flexibility and options.

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF