XMATCH Function in Excel - Two Examples of its Use

Описание: In this video, we look at the new XMATCH function and its improvements over the original MATCH function.

We look at two examples of how to use this awesome function and demonstrate its advantages.

Now, the XMATCH function is only available to Excel 365 users and in Excel Online.

The video shows it being used to return the position of an item in a range, and when used with the impressive INDEX function.

We then explore the extra options of INDEX by performing a wildcard search and looking back up a list.

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J

Connect with us!

LinkedIn ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1