If you’ve done lookups with VLOOKUP, INDEX/MATCH or even the new XLOOKUP, it usually just brings back one record or one match per cell. But what if you wanted a lookup to find multiple matches? Think you’d have to write crazy long formulas or VBA code?
Well with a neat dynamic array function in M365, it’s just a simple combination with other functions that will take you less than a couple minutes to put together...maybe even less that one minute, once you understand how it’s done.
No comments:
Post a Comment