Uploaded February 2026 | Updated November 2026, 2 days ago
Download the Practice Kit ⬇️ - goodly.co.in/you-dont-need-xlookup-and-vlookup
Register for the Power BI Foundations Workshop - goodly.co.in/power-bi-beginners-live-workshop
Join my Power BI Community - products.goodly.co.in/learn-dax-powerbi#:~:text=Start%20Your%20Learning%20Journey!
Do you really need XLOOKUP or VLOOKUP anymore?
In this video, I explain why I have started moving away from XLOOKUP and VLOOKUP, especially when working with large datasets. I show how these functions can slow down Excel files and create performance issues as the data grows.
I first show the problem using a large dataset, so you can clearly see where XLOOKUP and VLOOKUP start to struggle. Then, I walk you through a more scalable and reliable approach using Power Query, Power Pivot, and data relationships.
I also cover how to bring values from another table using the RELATED function and create dynamic calculations with a DAX measure using SUMX.
With this approach, you can work with data beyond a million rows, perform more structured and advanced analysis, and manage your Excel file size more efficiently.
If you want faster models, cleaner logic, and Excel files that scale with your data, this video will help you rethink how you use lookups in Excel.
youtu.be/6BdnQS-hZvw?si=YO1iKQ3qzes8hI1U
===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book
✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?
✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi
✔️ Power Query Course -
products.goodly.co.in/learn-power-query
✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
Download the Practice Kit ⬇️ - goodly.co.in/you-dont-need-xlookup-and-vlookup
=====CHAPTERS=====
00:00 - Intro
01:25 - Part 1
04:00 - Part 2
11:27 - Part 3
===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Download the Practice Kit ⬇️ - goodly.co.in/you-dont-need-xlookup-and-vlookup
Register for the Power BI Foundations Workshop - goodly.co.in/power-bi-beginners-live-workshop
Join my Power BI Community - products.goodly.co.in/learn-dax-powerbi#:~:text=Start%20Your%20Learning%20Journey!
Do you really need XLOOKUP or VLOOKUP anymore?
In this video, I explain why I have started moving away from XLOOKUP and VLOOKUP, especially when working with large datasets. I show how these functions can slow down Excel files and create performance issues as the data grows.
I first show the problem using a large dataset, so you can clearly see where XLOOKUP and VLOOKUP start to struggle. Then, I walk you through a more scalable and reliable approach using Power Query, Power Pivot, and data relationships.
I also cover how to bring values from another table using the RELATED function and create dynamic calculations with a DAX measure using SUMX.
With this approach, you can work with data beyond a million rows, perform more structured and advanced analysis, and manage your Excel file size more efficiently.
If you want faster models, cleaner logic, and Excel files that scale with your data, this video will help you rethink how you use lookups in Excel.
youtu.be/6BdnQS-hZvw?si=YO1iKQ3qzes8hI1U
===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book
✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?
✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi
✔️ Power Query Course -
products.goodly.co.in/learn-power-query
✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
Download the Practice Kit ⬇️ - goodly.co.in/you-dont-need-xlookup-and-vlookup
=====CHAPTERS=====
00:00 - Intro
01:25 - Part 1
04:00 - Part 2
11:27 - Part 3
===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!










