Highline Excel 2016 Class 13: One Lookup Value to Return Multiple Items: INDEX & AGGREGATE
Download Files: https://people.highline.edu/mgirvin/A...
In this video learn about how to create a formula that can take One Lookup Value and Return Multiple Items. Learn about the INDEX and AGGREGATE Array Formula. See the functions: with INDEX, AGGREGATE, ROW, ROWS and IF functions. Learn how IFERROR is inefficient to use with Array Formulas that extract multiple items with a single lookup value.
