Uploaded March 2025 | Updated November 2026, 3 hours ago
Do you want to VLOOKUP but in across sheets? Then you need this mind-blowing ๐คฏ trick.
๐ Sample file: chandoo.org/wp/wp-content/uploads/2025/03/vlookup-any-sheet.xlsx
๐ป 10% OFF My Excel Course - chandoo.org/wp/excel-school-program ๐๏ธ use code SUMPRODUCTIF
In this video:
1) How to lookup across multiple sheets
2) Introducing VSTACK to combine all the data
3) Using LET and variables
4) Getting Qty, Date & other details with one spillable formula
5) What if multiple matching values are there - using FILTER
๐ Video timestamps:
0:00 - VLOOKUP across multiple sheets - the problem
1:26 - VSTACK + XLOOKUP solution
3:45 - Two issues with this approach
4:24 - How to get other columns data too
5:58 - Getting "all" matching results from across sheets
๐งฎ Functions used and explained in this video:
======================================
XLOOKUP
VSTACK
LET
CHOOSECOLS
TRANSPOSE
FILTER
๐งโ๐ Want to learn Excel for real?
==========================
Do you want to learn how to use Excel for doing "actual" work? Check out my Excel School program and unlock your potential. I focus on practical examples like this and share real-world skills for your success.
GET 10% DISCOUNT with the coupon code SUMPRODUCTIF
Visit chandoo.org/wp/excel-school-program to join
~
#excel #vlookup
Do you want to VLOOKUP but in across sheets? Then you need this mind-blowing ๐คฏ trick.
๐ Sample file: chandoo.org/wp/wp-content/uploads/2025/03/vlookup-any-sheet.xlsx
๐ป 10% OFF My Excel Course - chandoo.org/wp/excel-school-program ๐๏ธ use code SUMPRODUCTIF
In this video:
1) How to lookup across multiple sheets
2) Introducing VSTACK to combine all the data
3) Using LET and variables
4) Getting Qty, Date & other details with one spillable formula
5) What if multiple matching values are there - using FILTER
๐ Video timestamps:
0:00 - VLOOKUP across multiple sheets - the problem
1:26 - VSTACK + XLOOKUP solution
3:45 - Two issues with this approach
4:24 - How to get other columns data too
5:58 - Getting "all" matching results from across sheets
๐งฎ Functions used and explained in this video:
======================================
XLOOKUP
VSTACK
LET
CHOOSECOLS
TRANSPOSE
FILTER
๐งโ๐ Want to learn Excel for real?
==========================
Do you want to learn how to use Excel for doing "actual" work? Check out my Excel School program and unlock your potential. I focus on practical examples like this and share real-world skills for your success.
GET 10% DISCOUNT with the coupon code SUMPRODUCTIF
Visit chandoo.org/wp/excel-school-program to join
~
#excel #vlookup

![How to make an employee time tracker with Excel [Easy setup]
๐ฅCheck out Connecteam ๐ https://connecteam.cc/3QSAjlQ
~
Recently I needed to make a timesheet solution for my clients. I used Excel 365 with forms to create a quick & elegant application. It works on phones, web browsers and PC. You can track shift information and consolidate the data at the end of month for payroll processing.
In this video, let me present you with the solution and approach I took.
For an easier and error proof solution, do check out the sponsor of this video Connecteam here - https://connecteam.cc/3QSAjlQ
~
Timestamps for the video:
0:00 - Demo of my time tracking app
1:06 - Creating the app using Excel on web
1:52 - Setting up the data entry form
3:45 - Adding Branching Logic to show different options based on the data entered.
4:32 - Saving and publishing the form (app)
5:30 - Testing our app
8:12 - The problem with our solution
8:45 - A better time tracking solution (with Connecteam)
~ How to make an employee time tracker with Excel [Easy setup]](https://i.ytimg.com/vi/ZJLYMYhtDRc/mqdefault.jpg)
![This formula changes how you make dashboards [TOPN in One Cell]
TEXTJOIN magic for your next dashboard This formula changes how you make dashboards [TOPN in One Cell]](https://i.ytimg.com/vi/Zj4tQP-Cptc/mqdefault.jpg)

![Whats the DIFFERENCE Between Data Engineer, Analyst, and Scientist?
Do you wonder what is the difference between a data analyst, engineer and scientist is? In this video, let me explain what these 3 roles are, what skills you need to get in, how the career path looks like, what is the typical salary and how the work feels. LETS GO!
โฑ IN THIS VIDEO:
0:00 - Data Engineer vs. Data Analyst vs. Data Scientist
0:35 - The rules
1:08 - What they do? DE vs. DA vs. DS
4:07 - Skills you need to be a Data Engineer
5:38 - Skills needed for Data Analyst
6:56 - Skills for Data Scientists
9:01 - Salaries for Data Engineer vs. Data Analyst vs. Data Scientist
11:24 - Career pathways for Data engineer / analyst / scientist
14:11 - People you work and how the work looks like
16:08 - Getting the skills
๐ WANT MORE?
If you want more, consider my paid courses. They are the best in the world when it comes to explaining complex data concepts in lucid and practical terms. Check out the courses using the links below and sign up today.
Essential Data Skills with Excel - https://chandoo.org/wp/excel-school-program/
Essential Data Skills with Power BI - https://chandoo.org/wp/power-bi-course/
๐บ DATA PLAYLISTS
Data Analyst vs. Business Analyst - What is the difference? - https://youtu.be/pIbL4aSUIas
Tech skills needed to be a data analyst: https://youtu.be/R3bZ0LLv3Fk
Data Analyst 3-month roadmap: https://youtu.be/x0Cd4TTOgwI
Day in the life of a Data Analyst: https://youtu.be/Lc55Y7Ai23Q
Top 10 Data Analyst interview questions: https://youtu.be/MX6Ee_ubE1s
7 critical mistakes to avoid in Data Analyst interviews: https://youtu.be/f7lBYh1_9BQ
5 Skills you need to be a GREAT data analyst: https://youtu.be/gVr9f1GJdZc
[Playlist] Data Analyst Skills: https://www.youtube.com/playlist?list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R
[Playlist] Data Careers, Interview and Job Prep: https://www.youtube.com/playlist?list=PLmejDGrsgFyAw9Qya6SgrXfcfKCn7Va_D
~
#dataengineer #datascientist #dataanalyst
~
Data analyst: The glass is 50% full ๐ฅ
Data scientist: The glass is over fitting the water ๐
Data Engineer: Somewhere a pipeline must have broken. Only half the water is loaded ๐ค Whats the DIFFERENCE Between Data Engineer, Analyst, and Scientist?](https://i.ytimg.com/vi/ZyRH6FMcVlw/mqdefault.jpg)





