Loading...

Highline Excel 2016 Class 13: One Lookup Value to Return Multiple Items: INDEX & AGGREGATE

16,087 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

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.

Loading...


to add this to Watch Later

Add to

Loading playlists...