ehardway123
New Member
- Joined
- May 24, 2013
- Messages
- 22
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
<tbody>
</tbody>
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>