Hi Chris.. interesting tips and techniques. Thanks for sharing! Thumbs up!!
@elfridhasman41813 жыл бұрын
Thank You
@bidyutchakraborty24334 жыл бұрын
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?
@briandennehy63804 жыл бұрын
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.
@ExcelMaven4 жыл бұрын
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
@briandennehy63804 жыл бұрын
@@ExcelMaven Definitely helpful, index and match still catch me out. Cheers for the tips