VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521)

FILTER Function: One or More Lookup Values Return One or More Returns Values EMT 1521
Download Excel File: https://ift.tt/2O0QoBY
In this video learn about THE Most Amazing Lookup function for dealing with Multiple Lookup Values or Multiple Returned values when doing lookup! Learn about the FILTER Function to filter data sets, columns, or to do complicated Lookups.
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)

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.