XMATCH Function in Excel - Two Examples of its Use

2K views May 16, 2023

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