Pivot Table Index and Match

[Dastnai]

Good Afternoon Everyone,

I have a table that I am trying to bring in values based upon a pivot table I created. My goal is to bring in the values for a specified date. My table is set up from the current day and out. I am struggling using get pivot data because my column of dates is a formula =now() + 1 ect. Any ideas on how to bring in the data with getpivotdata, index and match, ect?

I really appreciate anyone's input.

Here is how my table is set up:

(C)ustomer 11/16 11/17 11/18 11/19 ...............

a
b
c
d

My pivot table is set up the same way. However the pivot starts on the first day that there is data so it might look like this

(C) 11/18 11/19 .................

a values
b values
c
d

 

[SpillerBD]

NOW() gives a Date+Time value. Current Day uses the TODAY() function.

 

[Dastnai]

My question is in regards to looking up a value for specified dates given the same date in a pivot table. Does that make sense?

 

[SpillerBD]

My question is in regards to looking up a value for specified dates given the same date in a pivot table. Does that make sense?

If you are using dates in one field and using a VLOOKUP that has a Date/Time value, you'll only have success with approximate matching. Exact matching will never occur.
To use a Pivot Table for lookup, its layout and formatting must be of particular.
Without a better representation of your table, I must suggest the use of SUMPRODUCT. It avoids several issues of changing ranges of the Pivot Table. Your source data is not a proper data set as the dates are running across the top row.
SUMIFS is also another decent option.

https://www.youtube.com/watch?v=vxpeEf8MYaY