Lookup a list of values based on a date

[ctigers]

I have a list of names within the same time frame (1st quarter 2009 for example) on sheet A. Tried Vlookup but it only gives me the first name, need to list all names that fall with that time frame on sheet B

SHEET A
QUARTER	Name	Status	Dept #
1st Qtr 2009	April Vickery	W	21440
1st Qtr 2009	Doug Ware	W	21410
2nd Qtr 2009	Jimmy Selman	W	21430
1st Qtr 2009	Daisy Cowan	W	21431
3rd Qtr 2009	Mike Brenneman	W	21415
1st Qtr 2009	Stacy Gambrell	W	21430
2nd Qtr 2009	Connie Sanders	W	21660
2nd Qtr 2009	David Ables	W	21411
SHEET B
1st Qtr 2009
April Vickery
Doug Ware
Daisy Cowan
Stacy Gambrell

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>

 

[t0azt]

Enter this into A2 of sheet B and drag down.

=IFERROR(INDEX('Sheet A'!$B$2:$B$9,SMALL(IF('Sheet A'!$A$2:$A$9='Sheet B'!$A$1,ROW('Sheet A'!$A$2:$A$9)-ROW('Sheet A'!A$2)+1),ROWS('Sheet A'!A$2:A2))),"")

It is an array formula so use ctrl+shift+enter

 

[ctigers]

t0azt, formula works like a charm, thank you for your help!.....ctiger

 

[t0azt]

Thanks for the feedback. Glad I could help!