Learn Excel Advanced VLOOKUP and INDEX & MATCH with multiple criteria's [2021]
Автор: Erik
Загружено: 2021-08-25
Просмотров: 15190
Hi Guys,
In this video, I will be teaching you how to use VLOOKUP and INDEX and MATCH with 2-3 criteria.
Timestamp:
00:00 Intro
00:44 Helper Column
00:56 VLOOKUP with 2 Criteria using Helper Column
01:45 VLOOKUP with 3 Criteria using Helper Column
02:30 VLOOKUP with 2 Criteria using no Helper Column
04:00 VLOOKUP with 3 Criteria using no Helper Column
05:20 INDEX & MATCH with 2 Criteria
06:03 INDEX & MATCH with 3 Criteria
06:51 Outro
Don't forget to leave a comment/suggestions.
Thanks for stopping by.
--------------------------------------------------------------------------------
Excel / Google Sheets SUM / SUMIF / SUMIFS: • Learn SUM, SUMIF and SUMIFS function in 5m...
Excel IF and Nested IF:
• Learn Excel IF and Nested IF function in 3...
VLOOKUP, HLOOKUP, INDEX & MATCH and XLOOKUP
• Learn Lookup Formulas | VLOOKUP, HLOOKUP, ...
Advanced Filter
• Learn Excel's Advanced Filter in 5minutes ...
#msexcel #vlookup #indexandmatch
![Learn Excel Advanced VLOOKUP and INDEX & MATCH with multiple criteria's [2021]](https://ricktube.ru/thumbnail/LkBaf2NUHM4/hq720.jpg)
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
![Excel Drop Down List Tutorial | Learn to Create in 3 Different Ways [2021]✨](https://ricktube.ru/thumbnail/OaZ8SCGTEQU/mqdefault.jpg)
![Automate Your Excel Reports! | How to use VBA to automate repetitive tasks [2022] ✨](https://ricktube.ru/thumbnail/LslNCF9U7Eg/mqdefault.jpg)
![Learn Excel VBA to Automate Your Report in 13 minutes [2021]](https://ricktube.ru/thumbnail/qvbyuu6wOW4/mqdefault.jpg)