One Lookup Value, Return Multiple Items – The Easy Way with FILTER – Excel Magic Trick 1591

Download Excel File: https://ift.tt/30eo31Z
Learn how to return multiple items with one lookup value using the new Office 365 FILTER Dynamic Array Function. What to do if you have one lookup value and duplicate matches and you want to return multiple items?

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.