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

Key

driver

date

jan

feb

mar

apr

may

jun

jul

N

formula

Jakejan

jake

01/02/13

100.00

0

01/02/13

Jakejan

jake

01/11/13

150.00

1

01/11/13

Jakejan

jake

01/22/13

50.00

2

01/22/13

Janmar

jake

03/15/13

110.00

3

03/15/13

<tbody>
</tbody>

 

[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