Excel Forum



Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula


Duplicate Lookup or Lookup 1 value, return many for a column Part 2. Formula to return all the numbers from a column that contains text and numbers. See an array formula that uses the functions: COUNT, IF, ROWS, INDEX, ISNUMBER, SMALL. Return Multiple Items From One Lookup Value (One Lookup value is a number).
Related Videos: Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table, Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row





Got a Question? Ask it Here in the Forum.