Highline Excel 2016 Class 13

One Lookup Value to Return Multiple Items: INDEX & AGGREGATE

DESCRIPTION

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.

WORKBOOKS

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




Be the first to comment

Leave a Reply