Creating a Index/ Match formula within a pivot table with multiple Row Labels

TexasHeat

New Member
Joined
Aug 4, 2015
Messages
12
[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.
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,636
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top