sarahrosenberg
Board Regular
- Joined
- Aug 27, 2002
- Messages
- 190
I am trying to use GETPIVOTDATA on a pivot table with a lot of blank cells. The top of the pivot table is a "month/year" field. What I am trying to do is look up prices as of a certain date. In some instances the price data for that date is blank and I need my lookup formula to look up the previous price. For example, if the prices in my pivot are as follows:
01/06: $100
02/06: <blank>
03/06: <blank>
04/06: $85
05/06: $85
06/06: $78
07/06: <blank>
08/06: $75
I need my formula to pull $100 for 02/06 and 03/06 and $78 for 06/06. I pulled all the data - filling in the blanks - into a new table, but I have two row filters in addition to the data column filter and don't know that it is possible to do a vlookup / match with three filters?
Help!
Sarah
01/06: $100
02/06: <blank>
03/06: <blank>
04/06: $85
05/06: $85
06/06: $78
07/06: <blank>
08/06: $75
I need my formula to pull $100 for 02/06 and 03/06 and $78 for 06/06. I pulled all the data - filling in the blanks - into a new table, but I have two row filters in addition to the data column filter and don't know that it is possible to do a vlookup / match with three filters?
Help!
Sarah