I don't use VLOOKUP or XLOOKUP in Excel anymore, I do this instead

Project Files: https://www.teachexcel.com/excel-tuto... 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-tuto... ~~ 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