Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables & Vlookups | Excel Discussion (Misc queries) | |||
Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot tables, IF statements, vlookups? | Excel Worksheet Functions | |||
Vlookups in a Pivot table brining back OFFSET Data | Excel Worksheet Functions |