Vlook Up or Index formula required

[Celticshadow]

Hi Everyone

I have a sheet with my "source data" as below and I also have a second sheet with my required filtered data also as below.The second sheet has at every 6th row the name of the horse and shows the data I require to extract from my "source sheet" (whole rows of data associated to name of horse). Thus if as shown Slim is in cell A2 on the second sheet (lets call this sheet "req data") I want to look through the data in the "source sheet" and pull out the whole row of data (through A to E) and place it in date order descending in the "req sheet" again as shown. I have looked through some older posts on forum and came across an index formula with array but I am unable to fathom it and adjust it to suit thus may I kindly ask the board if they would be kind enough to help me out with this current problem. Many thanks in advance.

Regards


Source Data

	Horse	A	B	C	D	E
1	Nette	01 January 2011 <tbody> </tbody>	71	159	1 <tbody> </tbody>	A
2	Ters	01 January 2011 <tbody> </tbody>	65	115	2	X
3	Slim	11 January 2011 <tbody> </tbody>	60	102	5	R
4	Ally	03 February 2011 <tbody> </tbody>	54	107	7	T
5	Slim	11 February 2011 <tbody> </tbody>	53	106	1	G
6	Slim	05 April 2011 <tbody> </tbody>	52	81	6	B
7	Ally	03 July 2011 <tbody> </tbody>	21	73	5	X
8	Mont	02 March 2012 <tbody> </tbody>	87	101	3	E
9	Mont	04 March 2012 <tbody> </tbody>	67	98	0	R
10	Very	05 March 2012 <tbody> </tbody>	51	111	1	N
11	Nette	04 August 2012 <tbody> </tbody>	49	136	2	S
12	Ally	07 August 2013 <tbody> </tbody>	49	101	6	A

<tbody>
</tbody>

Req Data

	A	B	C	D	E	F	G
1	Horse	Date <tbody> </tbody>	Rating 1	Rating 2	Rating 3	Rating 4
2	Slim	11 January 2011 <tbody> </tbody>	60	102	5	R
3		11 February 2011 <tbody> </tbody>	53	106	1	G
4		05 April 2011	52	81	6	B
5
6
7
8	Ally	03 February 2011 <tbody> </tbody>	54	107	7	T
9		03 July 2011 <tbody> </tbody>	21	73	5	X
10		07 August 2013 <tbody> </tbody>	49	101	6	A
11
12
13
14	Mont	02 March 2012 <tbody> </tbody>	87	101	3	E
15		04 March 2012 <tbody> </tbody>	67	98	O	R
16
17
18
19

<tbody>
</tbody>

 

[Celticshadow]

Hi All

Please ignore the above as I have reposted below due to having problems with posting tables and trust that it looks a little tidier.

Regards

Hi Everyone

I have a sheet with my "source data" as below and I also have a second sheet with my required filtered data also as below.The second sheet has at every 6th row the name of the horse and shows the data I require to extract from my "source sheet" (whole rows of data associated to name of horse). Thus if as shown Slim is in cell A2 on the second sheet (lets call this sheet "req data") I want to look through the data in the column A on the "source sheet" and pull out the whole rows of data (through A to E) and place it in date order descending in the "req sheet" again as shown. I have looked through some older posts on forum and came across an index formula with array but I am unable to fathom it and adjust it to suit thus may I kindly ask the board if they would be kind enough to help me out with this current problem. Many thanks in advance.


Source Data

	A	B	C	D	E	F
1	Horse	Date	Rating1	Rating2	Rating3	Rating4
2	Nette	01 January 2011	71	159	1	A
3	Ters	01 January 2011	65	115	2	X
4	Slim	11 January 2011	60	102	5	R
5	Ally	03 February 2011	54	107	7	T
6	Slim	11 February 2011	53	106	1	G
7	Slim	05 April 2011	52	81	6	B
8	Ally	03 July 2011	21	73	5	X
9	Mont	02 March 2012	87	101	3	E
10	Mont	04 March 2012	67	98	0	R
11	Very	05 March 2012	51	111	1	N
12	Nette	04 August 2012	49	136	2	S
13	Ally	07 August 2013	49	101	6	A

<tbody>
</tbody>

Required Data

	A	B	C	D	E	F
1	Horse	Date	Rating1	Rating2	Rating3	Rating4
2	Slim	11 January 2011	60	102	5	R
3		11 February 2011	53	106	1	G
4		05 April 2011	52	81	6	B
5
6
7
8	Ally	03 February 2011	54	107	7	T
9		03 July 2011	21	73	5	X
10		07 August 2013	49	101	6	A
11
12
13
14	Mont	02 March 2012	87	101	3	E
15		04 March 2012	67	98	0	R

<tbody>
</tbody>