View original (French)

EXCEL VLOOKUP and PIVOT TABLE function

GEORGEDEGEORGE -  
gbinforme Posted messages 14930 Registration date   Status Contributeur Last intervention   -
Hello

I am facing a problem with the VLOOKUP function.

I have a pivot table as a source like this:
Region PROD GROUP Sum of Consi Sum of Overstock
A PRODUCT A 57 4
PRODUCT B 24 1
PRODUCT C 45 1
PRODUCT D 21 1
Total A 263 7
B PRODUCT A 57 4
PRODUCT B 2 1
PRODUCT C 52 1
PRODUCT D 21 1
Total B xxx 7

This source table may vary in the placement for the names "region" and "prod group" depending on the extraction of the day...

This is an indicator and since I can't make ratios on the right-hand columns (for stability reasons), I am therefore exporting my data to another sheet using the VLOOKUP function (region&prod group.....)

Sum of Consi Sum of Overstock
REGION A PRODUCT A xxx xx my ratios
REGION A PRODUCT B xxx xx my ratios
REGION A PRODUCT C xxx xx my ratios
REGION A PRODUCT D xxx xx my ratios

But the cells under A (or under B) are not filled (because of the pivot table) and therefore I can't import the values from the cells they refer to using the VLOOKUP formula...

There must be something, but I'm stumped..
Configuration: Windows XP Internet Explorer 6.0

1 réponse

Réponse 1 / 1
gbinforme Posted messages 14930 Registration date   Status Contributeur Last intervention   4 742
 
Hello

To work on a Pivot Table, try using the formula "GETPIVOTDATA"

It depends on the layout and complexity of your Pivot Table to use it, but it will allow you to get the hidden values.
--

Always stay zen
-1