Excel Forum



Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula


Duplicate Lookup or Lookup 1 value, return many for a row Part 3. See a formula that looks up one value and returns multiple items. One To Many Relationship. See an array formula that uses the functions: COUNTIF, IF, COLUMNS, INDEX, SMALL and ROW.
Related Videos: Excel Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column, Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table





Got a Question? Ask it Here in the Forum.