Another LookUp Question

[Beyond Me]

I have many rows of data held on a sheet called DataRecords. In column 'A' which holds an identifier and appears for four rows before the next group of four appears and so on.

On another sheet called Summary I need to set up a sort of lookup, which I'm struggling with (it will form a report). In cell A1 I want to enter the identifier and in cells A4:A7 a vlookup.

In cell A4 I'm currently using =VLOOKUP(A$1,ID,2,FALSE) which brings in the first record.

I realise that its finding the first row, how can I pick up the second row in cell A5?

This is my data:

Book1
	A	B	C	D	E	F	G	H
1	ID	01-Jan	02-Jan	03-Jan	04-Jan	05-Jan	06-Jan	07-Jan
2	A	0.831194	0.518265	0.096267	0.645199	0.706429	0.049946	0.727178
3	A	0.730161	0.125968	0.345368	0.073573	0.771482	0.940802	0.823102
4	A	0.900642	0.420847	0.347148	0.551012	0.697435	0.722171	0.648806
5	A	0.130333	0.208564	0.514502	0.133617	0.467968	0.129375	0.804516
6	S	0.358189	0.987024	0.774142	0.057636	0.255244	0.96097	0.898696
7	S	0.301517	0.410683	0.529034	0.851101	0.877308	0.254552	0.164747
8	S	0.189164	0.994705	0.212221	0.436611	0.166459	0.00498	0.120284
9	S	0.515858	0.448589	0.80054	0.317056	0.015637	0.777909	0.050943
DataRecords

This is what I'm after:

Book1
	A	B	C	D
1	A
2
3	This is what I'm getting.	This is what I should get
4	0.831193687	0.831193687
5	0.831193687	0.730161352
6	0.831193687	0.900642452
7	0.831193687	0.130332679
8
Summary

 

[Aladin Akyurek]

Book3
	A	B	C	D
1	A	4
2	1-Jan-06	1
3	0.831194
4	0.730161
5	0.900642
6	0.130333
7
Summary

A1:A2 houses user entries, an ID and a date, respectively.

B1:

=COUNTIF(DataRecords!$A$2:$A$9,A1)

B2:

=MATCH(A2,DataRecords!$B$1:$H$1,1)

A3:

=IF(ROWS($A$3:A3)<=$B$1,INDEX(DataRecords!$B$2:$H$9,SMALL(IF(DataRecords!$A$2:$A$9=$A$1,ROW(DataRecords!$A$2:$A$9)-ROW(DataRecords!$A$2)+1),ROWS($A$3:A3)),$B$2),"")

which is confirmed with control+shift+enter (not with enter) then copied down.