Pivot Tables & Vlookups
 

I´m trying to link a vlookup to a Pivot table, the problem is that every time
I change a parameter in the report filter, the number of columns in the table
changes; which messes up my formulas.

Is there a way to lock it?

Pivot Tables & Vlookups
 

John Pivot Table wrote:
I´m trying to link a vlookup to a Pivot table, the problem is that every time
I change a parameter in the report filter, the number of columns in the table
changes; which messes up my formulas.

Is there a way to lock it?

You could try INDEX/MATCH. Take a look at:

http://contextures.com/xlFunctions03.html

Pivot Tables & Vlookups
 

Another way to extract data from a pivot table is with a GetPivotData
formula. There's information and examples he

http://www.contextures.com/xlPivot06.html

John Pivot Table wrote:
I´m trying to link a vlookup to a Pivot table, the problem is that every time
I change a parameter in the report filter, the number of columns in the table
changes; which messes up my formulas.

Is there a way to lock it?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com