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

Опубликовано: 04 Октябрь 2024
на канале: Chandoo

231,084

5.1k

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

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/upl...

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

~VIDEOS~

VLOOKUP, INDEX & MATCH introduction video -    • How to use Excel VLOOKUP? Complete Be...
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/vlookup-match-...
XLOOKUP with 13 examples - https://chandoo.org/wp/xlookup-examples/
INDEX() - the most important formula in Excel - https://chandoo.org/wp/index-formula-...
Why I am using 1 in multi-condition lookup - https://chandoo.org/wp/advanced-sumpr...

~BOOKS & COURSES~

LOOKUPS for Data Analysis - https://chandoo.org/wp/lookups-for-da...
VLOOKUP Book - https://chandoo.org/wp/resources/get-...

~Playlist of Essential Excel Formulas~

   • 10 Advanced IF formulas every analyst...

~Happy learning 🌼🌞

#IndexMatch #ExcelTips