Excel Magic Trick 822: 4-Way Lookup When There ARE Duplicates (Return Multiple Items)




About this tutorial:

Video duration: 13:37
Download file:
See how to do a four way lookup when there ARE duplicates and you need to return multiple items from one lookup value
1. See how to do a Four way lookup when there are duplicate values to return from 1 lookup value
2. See a Helper Column Method
3. See an array formula method using AGGREGATE 2010 Excel function
4. See an array formula method using SMALL 2007 or 2003 Excel function

See related Video:
Excel 2010 Magic Trick 821: 4-Way Lookup When There Are No Duplicates 2007 and 2003 Methods

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *