Trying to get multiple data within the same group(s) (possible a vlookup or index function, not sure)
Take a look at the example
Trying to get multiple data within the same group(s) (possible a vlookup or index function, not sure)
Take a look at the example
Put this array formula in E3:
=IFERROR(INDEX($C$1:$C$10, SMALL(IF($B$1:$B$10=E$2, ROW($B$1:$B$10)), ROWS($A$1:$A1))), "")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Now copy E3 down about 5 rows, and across.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks