XLOOKUP Complete Tutorial in Excel (+ Hidden Tricks)
Автор: MyOnlineTrainingHub
Загружено: 2020-01-07
Просмотров: 373501
The new XLOOKUP function is better, easier and faster than VLOOKUP, HLOOKUP, INDEX & MATCH and OFFSET...oh, and you also don't need IFERROR to hide errors because it's built in.
👩🏫 Master Excel with my courses: https://bit.ly/xlookup20courses
⬇️ Download the example file here and follow along: https://bit.ly/xlookup20file
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/e...
🎯 FOLLOW me on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
==============
0:00 How to use the XLOOKUP Function
1:01 XLOOKUP syntax
1:37 Simple XLOOKUP
2:53 XLOOKUP does HLOOKUP
4:17 XLOOKUP does INDEX & MATCH
7:14 XLOOKUP Returns Multiple Columns
11:18 XLOOKUP Dynamic Range
13:37 XLOOKUP Error Handling
14:45 XLOOKUP Last Value
16:13 XLOOKUP Left
17:18 XLOOKUP Wildcards
18:25 XLOOKUP Approximate Match
#Excel #XLOOKUP #ExcelFunctions
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
