Excel Forum
Similar Content
Move Items between ListBox Controls
Tutorial: How to move single items as well as multiple items from one ListBox to another ListBox in ...
Filter Data to Show the Top 10 Items from a Data Set in Excel - AutoFilter
Macro: This Excel macro filters data in Excel in order to display the top 10 items from the data ...
Vlookup to Return the Min, Max, or Average Value in Excel
Tutorial: Perform a Vlookup that returns the highest value, lowest value, or average value from a d...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.