Since XLOOKUP and FILTER came about, they have become two of the most popular functions in Modern Excel. However, are you guilty of overusing XLOOKUP when FILTER would be the better choice? Knowing what each function is capable is important for returning accurate results. Check out this guide to discover a key difference between XLOOKUP and FILTER. ?? #exceleration #excel #globalexcelsummit
Great example. Also applies to XLOOKUP vs SUMIFS.
That "remember note" is the key. In one of her YouTube videos Leila Gharani called Filter as a "Vlookup that returns multiple values" (it doesn't have the limitations of the actual Vlookup) X-lookup can also return mulpliple values if your are returning an entire column or row.
I am guilty of over using Xlookup. However, I have started exploring the wonders of Filter function and it is amazing.
We still tend to create a pivot and get the max results rather than using Filter/Xlookup
Nice one! I must admit, I think that the XLOOKUP is a bit easier to follow. And it's all about making your formulas easier for others to understand what you've done!
I like them both. The TAKE function has been a nice addition as well.
Plant Controller with FP&A | Cost Accounting | MBA & Master's in Finance | bachelor's in Administration | Startup with Shelter | Financial Modeling | Automation | BI | Maquiladora | IMMEX | IFRS | US GAAP | AI | SOX
5 个月XLOOKUP