EXCEL PRO TIP: Many-to-Many Lookups
Рет қаралды 5,629
Күн бұрын
@wayneedmondson1065 4 жыл бұрын
Hi Chris.. interesting tips and techniques. Thanks for sharing! Thumbs up!!
@elfridhasman4181 3 жыл бұрын
Thank You
@bidyutchakraborty2433 4 жыл бұрын
Nice one, I kinda liked it.
@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?
@User_Notion Жыл бұрын
Can't we do this easily with Xlookup now? With search from last to first option?
@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 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 4 жыл бұрын
@@ExcelMaven Definitely helpful, index and match still catch me out. Cheers for the tips
@monsieurdiecasts3393 4 жыл бұрын
5 stars GTA most wanted
Rebekah Oster - Excel Power Up
Рет қаралды 36 М.