The Secret VLOOKUP Trick that Lookups Multiple Sheets ๐Ÿš€ @chandoo_
The Secret VLOOKUP Trick that Lookups Multiple Sheets ๐Ÿš€  @chandoo_
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
The Secret VLOOKUP Trick that Lookups Multiple Sheets ๐Ÿš€10 Advanced XLOOKUP Tips & TricksHow to make an employee time tracker with Excel [Easy setup]This formula changes how you make dashboards [TOPN in One Cell]Dynamic Moving Average with Excel OFFSETWhats the DIFFERENCE Between Data Engineer, Analyst, and Scientist?Here is why I think Excel skills are still relevant in the age of AIHow to implement Dense Rank in Excel (easy formula)3 Resume Tips for Data Analysts that actually work #jobsearchTop 10 Power BI Interview Questions (based on what I usually ask)5 POWER Tips to Analyze Data in Excel - End to End Project with Real Life DataHow to use DAX to analyze New vs. Returning Customers in Power BI
Chandoo |

The Secret VLOOKUP Trick that Lookups Multiple Sheets ๐Ÿš€

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER