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

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT358-369.xls 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