Description
Project Files: https://www.teachexcel.com/excel-tutorial/2730/e?src=yt_DBtMD2TfADY
Excel Tips by Email: https://tips.teachexcel.com
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, including VLOOKUP and XLOOKUP functions.
If you'd like to learn more about automating Excel, check our Excel Automation Courses (linked below).
I hope you enjoy the video! :)
Don
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~ 📥 Download the Practice Files (Free) ~~
https://www.teachexcel.com/excel-tutorial/2730/e?src=yt_DBtMD2TfADY
~~ Automation Courses (50-80% off) ~~
https://courses.teachexcel.com/
~~ AI Course Pre-signup Discount ~~
https://notify.teachexcel.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
00:00 Intro
00:10 What’s Covered
00:27 Get a single record/row from a dataset
03:28 Return multiple records from a dataset
05:17 Return only specific data from the main list (CHOOSECOLS function)
08:03 Sort lookup values
09:23 Get the highest values from a list in Excel
10:32 Dynamic data search in Excel
12:55 AI Lookup in Excel
#Excel #ai #copilot #finance #data