FILTER vs VLOOKUP, INDEX/MATCH, XLOOKUP, SUMIFS
In this video, which is part of Microsoft’s Modern Excel webcast series, we’ll cover the basic syntax of FILTER and then see how it compares to VLOOKUP, INDEX/MATCH, XLOOKUP, and SUMIFS. The question is: can FILTER accomplish the tasks we typically associate with these powerful Excel functions?
Note: not all versions of Excel contain the FILTER function. At the time of this writing, it is available in Excel 365 subscription only, and not in perpetual license versions such as Excel 2019, 2016, 2013, 2010, and so on.
Excel is not what it used to be.
You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.
Want to learn Excel?
Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.