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?
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.
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
Hi Chris.. interesting tips and techniques. Thanks for sharing! Thumbs up!!
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?
Can't we do this easily with Xlookup now? With search from last to first option?
Nice one, I kinda liked it.
Thank You
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.
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
@@ExcelMaven Definitely helpful, index and match still catch me out. Cheers for the tips
5 stars GTA most wanted