Lookup a list of values based on a date

ctigers

New Member
Joined
Nov 6, 2013
Messages
44
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
QUARTERNameStatusDept #
1st Qtr 2009April VickeryW 21440
1st Qtr 2009Doug WareW 21410
2nd Qtr 2009Jimmy SelmanW 21430
1st Qtr 2009Daisy CowanW 21431
3rd Qtr 2009Mike BrennemanW 21415
1st Qtr 2009Stacy GambrellW 21430
2nd Qtr 2009Connie SandersW 21660
2nd Qtr 2009David AblesW 21411
SHEET B
1st Qtr 2009
April Vickery
Doug Ware
Daisy Cowan
Stacy Gambrell

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

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

t0azt

Board Regular
Joined
Aug 1, 2012
Messages
134
Enter this into A2 of sheet B and drag down.

Code:
=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

New Member
Joined
Nov 6, 2013
Messages
44
t0azt, formula works like a charm, thank you for your help!.....ctiger
 

Watch MrExcel Video

Forum statistics

Threads
1,108,808
Messages
5,524,995
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top