XMATCH Function in Excel - Two Examples of its Use
Автор: Computergaga
Загружено: 2019-09-23
Просмотров: 36290
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
