Highline Excel 2016 Class 13

One Lookup Value to Return Multiple Items: INDEX & AGGREGATE


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.


Download “Highline Excel 2016 Class 13” Highline-Excel-2016-Class-13.zip – Downloaded 70 times – 504 KB

Be the first to comment

Leave a Reply