Nth occurrence

[Bugas]

Hi!

My table looks this:

	x	y	z	aa	ab
100	Client	Jan-12	Fev-12	Mar-12	Apr-12
101	aaa	1	1	3	1
102	bbb	3	2	1	2
103	ccc	1	2	1	2
104	ddd	4	4	3	4
105	eee	5	4	5	4
106	fff	5	6	5	6
107	ggg	5	6	7	6
108	hhh	5	8	8	8

<tbody>
</tbody>

For Jan-12 I would get this information:

	Jan-12
1	aaa
1	ccc
3	bbb
4	ddd
5	eee
5	fff
5	ggg
5	hhh

<tbody>
</tbody>

I'm trying to get the second, third, ... occurrence. It's not starting on A1. When I use vlookup, I only get the first occurance, ignoring the 2nd or the 3rd. I

I want to use excel formula.

 

[Bugas]

Thanks everyone! Works perfect

 

[Robert Mika]

Thanks everyone! Works perfect

You are welcome.Apprecieate the feedback.