If, index, match formulas together

[ehardway123]

Hey all, I am trying to get this formula to work properly. I want it to be able to grab the data for the selection of the date that was made. For instance, if I want to show only dates of the driver jake for Jan, then it will only return those dates for that month. Right now, the formula I have grabs all the dates. This is the current formula: =IF(A3='calc 2'!$A$9,INDEX(data,MATCH('calc 2'!$A$9,key,0)+N3,3),0) . How do I get it to only grab dates for Jakejan? Btw, calc2!$A$9 is where the selection is made. below is a sample of the data: Please help thanks, Erica[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Key[/TD]
[TD]driver[/TD]
[TD]date[/TD]
[TD]jan[/TD]
[TD]feb[/TD]
[TD]mar[/TD]
[TD]apr[/TD]
[TD]may[/TD]
[TD]jun[/TD]
[TD]jul[/TD]
[TD][/TD]
[TD]N[/TD]
[TD]formula[/TD]
[/TR]
[TR]
[TD]Jakejan[/TD]
[TD]jake[/TD]
[TD]01/02/13[/TD]
[TD]100.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]01/02/13[/TD]
[/TR]
[TR]
[TD]Jakejan[/TD]
[TD]jake[/TD]
[TD]01/11/13[/TD]
[TD]150.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]01/11/13[/TD]
[/TR]
[TR]
[TD]Jakejan[/TD]
[TD]jake[/TD]
[TD]01/22/13[/TD]
[TD]50.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]01/22/13[/TD]
[/TR]
[TR]
[TD]Janmar[/TD]
[TD]jake[/TD]
[TD]03/15/13[/TD]
[TD][/TD]
[TD][/TD]
[TD]110.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]03/15/13[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

Something like this??

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Key	driver	date	jan	feb	mar	apr	may	jun	jul
2	Jakejan	jake	1/2/2013	100
3	Jakejan	jake	1/11/2013	150
4	Jakejan	jake	1/22/2013	50
5	Janmar	jake	3/15/2013			110
6
7
8
9
10	Key =	Jakejan
11
12	Key	driver	date
13	Jakejan	jake	1/2/13
14	Jakejan	jake	1/11/13
15	Jakejan	jake	1/22/13
16
Sheet