Get my LOOKUPS for Data Analysis course https://chandoo.org/wp/lookupsforda...

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:
===============
https://chandoo.org/wp/wpcontent/upl...


More on INDEX MATCH & Other lookup functions
========================================

~VIDEOS~

VLOOKUP, INDEX & MATCH introduction video    • Excel VLOOKUP   Complete tutorial & ...  
5 Advanced VLOOKUP tricks    • 5 *Advanced* lookup tricks that Data ...  
XLOOKUP Why I don't use INDEX+MATCH anymore    • STOP using INDEX MATCH in Excel, use ...  

~ARTICLES~

VLOOKUP, INDEX & MATCH https://chandoo.org/wp/vlookupmatch...
XLOOKUP with 13 examples https://chandoo.org/wp/xlookupexamples/
INDEX() the most important formula in Excel https://chandoo.org/wp/indexformula...
Why I am using 1 in multicondition lookup https://chandoo.org/wp/advancedsumpr...

~BOOKS & COURSES~

LOOKUPS for Data Analysis https://chandoo.org/wp/lookupsforda...
VLOOKUP Book https://chandoo.org/wp/resources/get...

~Playlist of Essential Excel Formulas~

   • 10 Advanced IF formulas every analyst...  



~Happy learning

#IndexMatch #ExcelTips