Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 16, 2016
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.