Never Use Vlookup or Xlookup in Excel Again

VLOOKUP and XLOOKUP are done!

In this tutorial, you'll learn how to use new Excel functions, including FILTER, CHOOSECOLS, TAKE, SORT, and even an AI Version of a lookup instead of older slower and more complex lookup functions in Excel.

Instead of creating helper columns, applying filters, copying data, deleting rows, and building multiple lookup formulas, you'll see how a single custom FILTER formula can return exactly the records you need.

We'll cover practical examples including:

• Return a single entire row based on a search value
• Use Copilot AI in Excel to create data lookups
• Return multiple matching records instantly
• Return only specific columns of data using the CHOOSECOLS function
• Building dynamic reports that update automatically
• Create Top 10 lists with FILTER, SORT, and TAKE
• Search your data like Google with FILTER + SEARCH
• Filter with multiple criteria without helper columns
• Build interactive dashboards using dynamic arrays

By the end of the video, you'll understand why FILTER, combined with other new Excel functions, is one of the most powerful functions in modern Excel and how it can replace several traditional Excel workflows with a single formula.

If you'd like to learn more about automating Excel, check our Excel Automation Courses.

I hope you enjoy the video! :)

Don