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)