XLOOKUP but wrong results?!?

Описание: 💥Get my XLOOKUP Course ~ https://chandoo.org/wp/lookups-for-da...

Time for a tricky XLOOKUP (or just VLOOKUP problem). I have with me a product price list with a twist. There is an effective date for the price. So if I try to lookup for a product, my XLOOKUP (and VLOOKUP, as well as INDEX MATCH) results are wrong.

If there is one thing at Awesome Chocolates that we hate, it is the Crumbly Cookies. They are our competitor. But we also hate the wrong formulas. So let's get fixing. 🛠

In this video ⏱👇:
===============
0:00 - The problem
2:05 - One way to solve the problem (with MAXIFS & FILTER)
4:05 - Using XLOOKUP to solve the problem
5:08 - Moral of the story

Sample workbook 🟩👉
===================
Please download the sample workbook here - https://chandoo.org/wp/wp-content/upl...
and practice the concepts.


💥Get my XLOOKUP Course
=======================

Learn and master XLOOKUP, INDEX+MATCH, 2-way lookups, multi-condition lookups and more powerful techniques from my comprehensive XLOOKUP course - https://chandoo.org/wp/lookups-for-da...

You can also watch this course for free if you are SKILLSHARE member, here 👉 https://skl.sh/3hbR49d

More videos on XLOOKUP & Other lookups:
===================================

What is XLOOKUP and how to use it?    • I don't use VLOOKUP anymore. I use this in...  
What is FILTER and how to use it?    • I don’t use filters in Excel anymore. I us...  
What is VLOOKUP and how to use it?    • How to use Excel VLOOKUP? Complete Beginne...  
What is INDEX MATCH and how to use it?    • Excel's INDEX + MATCH - How to use it // 7...  
What is the best way to lookup things in Excel?    • Easiest Lookup formulas for any situation ...  
5 Advanced VLOOKUP Tricks -    • 5 *Advanced* lookup tricks that Data Analy...  

~

You have a beautiful day 😀🌼🌞

#xlookup #exceltips