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
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>
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>