lookup and return multiple rows?

[FootBallBat]

I am trying to have a formula search Column "A" for whats in "E1" then return the name and 5 rows below it.

	A	B	C	D	E	F	G	H
1	James				James	James
2	350					350
3	150					150
4	600					600
5	50					50
6	23					23
7
8

<tbody>
</tbody>

 

[FootBallBat]

Sorry I want the 6 rows total to be returned to column F

 

[Takae]

F2=OFFSET($A$1,MATCH($E$1,$A$1:$A$20,0)+ROW()-2,0)
Copy to down.

 

[FootBallBat]

Thank you, thats perfect.