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


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Tutorial Details
Excel Function: FILTER()
Excel Version: Excel 365
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)