STOP using INDEX MATCH in Excel, use this instead!!!

Excel's INDEX+MATCH formula is a staple for many. But do you know that Excel now has a simple alternative to this powerful formula combination? Yes, I haven't used INDEX MATCH function in over a year and here is why.

👉 XLOOKUP 👈

The magic new function can do what INDEX+MATCH does with a simpler syntax and offers many extra features. In this video, I will show you how you can replace your messy INDEX+MATCH formulas with simpler XLOOKUP variation.

Timestamps:
===========
0:00 - Introduction
0:09 - XLOOKUP overview & demo
1:10 - INDEX MATCH replacement with XLOOKUP
2:54 - Dealing with errors & If not found option in XLOOKUP
3:40 - One more example of XLOOKUP
4:09 - Advanced use of XLOOKUP - showing all details for matching values
5:35 - Closing remarks

Example file + more on XLOOKUP:
===========================

https://chandoo.org/wp/xlookup-examples/

👉Checkout my online course on Advanced Excel & Data analysis
===================================================

💻📗💥 https://chandoo.org/wp/excel-school-program/

#XLOOKUP #ExcelTricks

Видео STOP using INDEX MATCH in Excel, use this instead!!! канала Chandoo