FILTER() Function Excel - Power Lookup for the Future

Add to Favorites
Author: | Edits: don

The new FILTER() function for Excel 365 allows you to do amazing things with a single simple function, including powerful lookups that return multiple results.

New Excel 365 Formulas Course

The FILTER() function is new for Excel 365 and it uses the new calc engine to return all results form a list that match a certain criteria, which is similar to a Vlookup that returns multiple results.

This is a filtering function where you input the criteria and it returns all matches.

This single simple function replaces what used to require complex and confusing array formulas in Excel - this function makes your life much easier!

The filtering abilites of this function include:

  • matching one of multiple criteria
  • matching all criteria
  • returning multiple results
  • returning single results
  • returning entire data sets
  • returning parts of data sets

This formula uses the new spill feature and calc engine for Excel and it is definitely the future of Excel!

I hope you enjoy this tutorial!


Excel Function: FILTER()
Excel Version: Excel 365
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

Professional Input Forms in Excel

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

Send Emails from Excel

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.