EXCEL PRO TIP: Many-to-Many Lookups

  Рет қаралды 5,907

Excel Maven

Excel Maven

Күн бұрын

For access to all pro tips, along with Excel project files, PDF slides, quizzes and 1-on-1 support, upgrade to the full course (75% OFF):
courses.excelm...
FULL COURSE DESCRIPTION:
This course is NOT an introduction to Excel.
It's not about 101-style deep dives, or about showing off cheesy, impractical "hacks".
It's about featuring some of Excel's most powerful and effective tools, and sharing them through crystal clear demos and unique, real-world case studies.
We'll cover 75+ tools & techniques, organized into six categories:
-Productivity
-Formatting
-Formulas
-Visualization
-PivotTables
-Analytics
Demos are self-contained and ranked by difficulty, so you can explore the content freely and master these tools and techniques in quick, bite-sized lessons.
Full course includes LIFETIME access to:
-10+ hours of high-quality video content
-Downloadable PDF eBook
-Excel project files (including data sets & solutions)
-1-on-1 expert support
-100% satisfaction guarantee (no questions asked!)
Happy analyzing!
-Chris (Founder, Excel Maven)

Пікірлер: 9
@wayneedmondson1065
@wayneedmondson1065 4 жыл бұрын
Hi Chris.. interesting tips and techniques. Thanks for sharing! Thumbs up!!
@bidyutchakraborty2433
@bidyutchakraborty2433 4 жыл бұрын
Nice one, I kinda liked it.
@elfridhasman4181
@elfridhasman4181 4 жыл бұрын
Thank You
@User_Notion
@User_Notion 2 жыл бұрын
Can't we do this easily with Xlookup now? With search from last to first option?
@mdshahzada693
@mdshahzada693 Жыл бұрын
We are deliberately pulling the value for the 2 nd instance. How would this ensure that the order came from the store in 2nd store? What if the order is from store in the 1st instance?
@briandennehy6380
@briandennehy6380 4 жыл бұрын
Kinda limited. Youd need to have your lookup table sorted smallest to largest for this to work. I would suggest power query and merge both queries to get all matches of address for each store ID.
@ExcelMaven
@ExcelMaven 4 жыл бұрын
Yup, definitely limited and not as flexible as other options like PQ or XLOOKUP. That said, it’s a good way to get comfortable nesting some of these stats and lookup functions to make them more dynamic, and a helpful workaround in a pinch
@briandennehy6380
@briandennehy6380 4 жыл бұрын
@@ExcelMaven Definitely helpful, index and match still catch me out. Cheers for the tips
@monsieurdiecasts3393
@monsieurdiecasts3393 4 жыл бұрын
5 stars GTA most wanted
EXCEL PRO TIP: Hidden Chart Source Data
2:51
Excel Maven
Рет қаралды 1,7 М.
EXCEL PRO TIP: CUBE Functions
16:29
Excel Maven
Рет қаралды 12 М.
1, 2, 3, 4, 5, 6, 7, 8, 9 🙈⚽️
00:46
Celine Dept
Рет қаралды 81 МЛН
ЗНАЛИ? ТОЛЬКО ОАЭ 🤫
00:13
Сам себе сушист
Рет қаралды 4,2 МЛН
You Won’t Believe What Excel’s Copilot Can Do! (new updates)
10:37
EXCEL PRO TIP: Relational Data Models
10:30
Excel Maven
Рет қаралды 21 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 568 М.
Manage Many to Many Relationships in Power Pivot
17:27
Paula's Web3 & Crypto
Рет қаралды 173 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 238 М.
EXCEL PRO TIP: Color & Border Design
7:10
Excel Maven
Рет қаралды 73 М.
Insanely Useful Lookup Tricks in Excel
13:07
Goodly
Рет қаралды 8 М.
EXCEL PRO TIP: Pivot Slicers & Timelines
10:30
Excel Maven
Рет қаралды 3,8 М.
When Should You Use the Hash Sign in Excel Formulas?
10:53
Leila Gharani
Рет қаралды 1,1 МЛН
1, 2, 3, 4, 5, 6, 7, 8, 9 🙈⚽️
00:46
Celine Dept
Рет қаралды 81 МЛН