Lookup a list of values based on a date

ctigers

New Member
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>

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
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
t0azt, formula works like a charm, thank you for your help!.....ctiger

t0azt

Board Regular
Thanks for the feedback. Glad I could help!