Excel's INDEX + MATCH - How to use it // 7 real-world examples & tips

Get my LOOKUPS for Data Analysis course - https://chandoo.org/wp/lookups-for-data-analysis/

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/wp-content/uploads/2021/08/index-match-explained-dl.xlsx
More on INDEX MATCH & Other lookup functions
========================================

~VIDEOS~

VLOOKUP, INDEX & MATCH introduction video - https://youtu.be/8rtvDQVQaA0
5 Advanced VLOOKUP tricks - https://youtu.be/240fbiyFFKI
XLOOKUP - Why I don't use INDEX+MATCH anymore - https://youtu.be/gpwqUc3y7ZA

~ARTICLES~

VLOOKUP, INDEX & MATCH - https://chandoo.org/wp/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/
XLOOKUP with 13 examples - https://chandoo.org/wp/xlookup-examples/
INDEX() - the most important formula in Excel - https://chandoo.org/wp/index-formula-usage-and-tips/
Why I am using 1 in multi-condition lookup - https://chandoo.org/wp/advanced-sumproduct-queries/

~BOOKS & COURSES~

LOOKUPS for Data Analysis - https://chandoo.org/wp/lookups-for-data-analysis/
VLOOKUP Book - https://chandoo.org/wp/resources/get-vlookup-book/

~Playlist of Essential Excel Formulas~

https://www.youtube.com/watch?v=-yFpzIRifK4&list=PLmejDGrsgFyDbGPi_5idB0RSWgTX3HPtM
~Happy learning 🌼🌞

#IndexMatch #ExcelTips

Видео Excel's INDEX + MATCH - How to use it // 7 real-world examples & tips канала Chandoo