Vlookup or If statement using date ranges, pull in data if cell is within a range

[sheahan]

I'm trying to automatically populate 4 different tables with data from a single table based on the date in which the description occured. If its in Q1, then put data in Q1 table, etc. I appreciate any ideas you may have

Date	team	description		Q1</SPAN>	1/12-3/12</SPAN>
8/16/12</SPAN>	<st1:stockticker>ABC</st1:stockticker> </SPAN>	description 19 entered here</SPAN>		Date</SPAN>	Team</SPAN>	Description</SPAN>
7/28/12</SPAN>	DEF</SPAN>	description 18 entered here</SPAN>
7/28/12</SPAN>	<st1:stockticker>ABC</st1:stockticker> </SPAN>	description 17 entered here</SPAN>
7/26/12</SPAN>	<st1:stockticker>ABC</st1:stockticker> </SPAN>	description 16 entered here</SPAN>
9/4/12</SPAN>	DEF</SPAN>	description 15 entered here</SPAN>
7/14/12</SPAN>	DEF</SPAN>	description 14 entered here</SPAN>
10/7/12</SPAN>	<st1:stockticker>ABC</st1:stockticker> </SPAN>	description 13 entered here</SPAN>
7/2/12</SPAN>	DEF</SPAN>	description 12 entered here</SPAN>		Q2</SPAN>	4/12-6/12</SPAN>
6/30/12</SPAN>	<st1:stockticker>ABC</st1:stockticker> </SPAN>	description 11 entered here</SPAN>		Date</SPAN>	Team</SPAN>	Description</SPAN>
6/29/12</SPAN>	<st1:stockticker>ABC</st1:stockticker> </SPAN>	description 10 entered here</SPAN>
11/25/12</SPAN>	DEF</SPAN>	description 9 entered here</SPAN>
6/22/12</SPAN>	DEF</SPAN>	description 8 entered here</SPAN>
6/20/12</SPAN>	<st1:stockticker>ABC</st1:stockticker> </SPAN>	description 7 entered here</SPAN>
12/30/12</SPAN>	<st1:stockticker>ABC</st1:stockticker> </SPAN>	description 6 entered here</SPAN>
6/18/12</SPAN>	<st1:stockticker>ABC</st1:stockticker> </SPAN>	description 5 entered here</SPAN>
6/17/12</SPAN>	DEF</SPAN>	description 4 entered here</SPAN>		Q3</SPAN>	7/12-9/12</SPAN>
6/11/12</SPAN>	DEF</SPAN>	description 3 entered here</SPAN>		Date</SPAN>	Team</SPAN>	Description</SPAN>
6/6/12</SPAN>	<st1:stockticker>ABC</st1:stockticker> </SPAN>	description 2 entered here</SPAN>
6/1/12</SPAN>	DEF</SPAN>	description 1 entered here</SPAN>
5/1/12</SPAN>	DEF</SPAN>	description 0 entered here</SPAN>
5/9/12</SPAN>	<st1:stockticker>ABC</st1:stockticker> </SPAN>	description 20 entered here</SPAN>
4/7/12</SPAN>	DEF</SPAN>	description 21 entered here</SPAN>
3/8/12</SPAN>	<st1:stockticker>ABC</st1:stockticker> </SPAN>	description 22 entered here</SPAN>
1/8/12</SPAN>	DEF</SPAN>	description 23 entered here</SPAN>		Q4</SPAN>	10/12-12/12</SPAN>
				Date</SPAN>	Team</SPAN>	Description</SPAN>

<TBODY>
</TBODY>