Get my LOOKUPS for Data Analysis course - [ Ссылка ]
Excel's INDEX+MATCH is a powerful formula alternative to the traditional VLOOKUP. In this *DETAILED* video, learn all about INDEX MATCH combination, how to set it up, how to use it with plenty of examples. Refer to the sample file (link below) to practice the formula.
⏱ In this video:
=============
0:00 - Introduction
0:46 - INDEX MATCH - what is it and how to write the formula
2:55 - What to do when there is an error
4:03 - Combine two tables with INDEX MATCH functions
5:10 - Stacked data with INDEX MATCH
6:45 - Multiple conditions (criteria) with INDEX MATCH
9:01 - INDEX MATCH MATCH function for two way lookup
10:39 - Alternative to INDEX MATCH (XLOOKUP)
11:17 - More examples on Lookups
📁📗 Sample file:
===============
[ Ссылка ]
More on INDEX MATCH & Other lookup functions
========================================
~VIDEOS~
VLOOKUP, INDEX & MATCH introduction video - [ Ссылка ]
5 Advanced VLOOKUP tricks - [ Ссылка ]
XLOOKUP - Why I don't use INDEX+MATCH anymore - [ Ссылка ]
~ARTICLES~
VLOOKUP, INDEX & MATCH - [ Ссылка ]
XLOOKUP with 13 examples - [ Ссылка ]
INDEX() - the most important formula in Excel - [ Ссылка ]
Why I am using 1 in multi-condition lookup - [ Ссылка ]
~BOOKS & COURSES~
LOOKUPS for Data Analysis - [ Ссылка ]
VLOOKUP Book - [ Ссылка ]
~Playlist of Essential Excel Formulas~
[ Ссылка ]
~Happy learning 🌼🌞
#IndexMatch #ExcelTips
![](https://i.ytimg.com/vi/kly0uPIM4IU/maxresdefault.jpg)