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
Смотрите видео XMATCH Function in Excel - Two Examples of its Use онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Computergaga 23 Сентябрь 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 35,949 раз и оно понравилось 335 людям.