[TABLE="width: 612"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Row Labels
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Vehicle/ Fuel Date[/TD]
[TD] Days Between Fueling[/TD]
[/TR]
[TR]
[TD]10053930
[/TD]
[TD]Days Between Fueling[/TD]
[TD][/TD]
[TD][/TD]
[TD]12497290[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]421115 F150[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 01/06/2015[/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD] 01/07/2015[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 01/13/2015[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]LUKE KELL[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 03/02/2015[/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD]HOUMA[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 03/24/2015[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD] 01/14/2015[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 04/13/2015[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]STEWART DANIEL J[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 04/24/2015[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]HOUMA[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 05/07/2015[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD] 01/21/2015[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 05/20/2015[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]LUKE KELL[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 05/28/2015[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]HOUMA[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 06/03/2015[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD] 01/28/2015[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 06/21/2015[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]STEWART DANIEL J[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD]12492461[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]HOUMA[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 01/06/2015[/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD] 03/04/2015[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 01/16/2015[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]LUKE KELL[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 03/02/2015[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]HOUMA[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 03/17/2015[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD] 03/11/2015[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 03/24/2015[/TD]
[TD="align: right"]7[/TD]
[/TR]
</tbody>[/TABLE]
In the above segment of my pivot table you will see several different row labels including; vehicle number, vehicle description, fuel date, driver, and location. I'm trying to use the table on the right that has presorted and calculated information to index/match the vehicle number and date on the left in order to incorporate the "Days between fueling". The problem is my formula keeps wanting to just go to the next line item instead of referencing the vehicle number for the sub labels and then changing only when a new vehicle number presents itself. How can I get it to only focus on the vehicle number? I have bolded the vehicle number to help identify which are vehicle numbers. Also, obviously the vehicle number on the left doesn't match the ones on the right as it is located somewhere in the 7,000 cells of data that proceed.
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Row Labels
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Vehicle/ Fuel Date[/TD]
[TD] Days Between Fueling[/TD]
[/TR]
[TR]
[TD]10053930
[/TD]
[TD]Days Between Fueling[/TD]
[TD][/TD]
[TD][/TD]
[TD]12497290[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]421115 F150[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 01/06/2015[/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD] 01/07/2015[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 01/13/2015[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]LUKE KELL[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 03/02/2015[/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD]HOUMA[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 03/24/2015[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD] 01/14/2015[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 04/13/2015[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]STEWART DANIEL J[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 04/24/2015[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]HOUMA[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 05/07/2015[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD] 01/21/2015[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 05/20/2015[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]LUKE KELL[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 05/28/2015[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]HOUMA[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 06/03/2015[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD] 01/28/2015[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 06/21/2015[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]STEWART DANIEL J[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD]12492461[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]HOUMA[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 01/06/2015[/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD] 03/04/2015[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 01/16/2015[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]LUKE KELL[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 03/02/2015[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]HOUMA[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 03/17/2015[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD] 03/11/2015[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 03/24/2015[/TD]
[TD="align: right"]7[/TD]
[/TR]
</tbody>[/TABLE]
In the above segment of my pivot table you will see several different row labels including; vehicle number, vehicle description, fuel date, driver, and location. I'm trying to use the table on the right that has presorted and calculated information to index/match the vehicle number and date on the left in order to incorporate the "Days between fueling". The problem is my formula keeps wanting to just go to the next line item instead of referencing the vehicle number for the sub labels and then changing only when a new vehicle number presents itself. How can I get it to only focus on the vehicle number? I have bolded the vehicle number to help identify which are vehicle numbers. Also, obviously the vehicle number on the left doesn't match the ones on the right as it is located somewhere in the 7,000 cells of data that proceed.