Using Vlookup in Pivot Table Calculated Fields 
Author Message
 Using Vlookup in Pivot Table Calculated Fields

Can vlookups be used as a formula in the pivot tables calculated
fields?  I can't seem to get it to work.  Do the calculated fields
only accept simple formulas?

Thanks,

Brent



Sat, 07 Aug 2004 22:39:34 GMT  
 Using Vlookup in Pivot Table Calculated Fields
Hi Brent

AFAIK you cannot use VLOOKUP in the way you describe.
You would need to add a further column to your table of Data, and utilise
the VLookup function there.
You could then use this new field in the Pivot Table, rather tan having a
calculated PT filed.

--
Regards

Roger Govier
Technology 4 U             W98  XL2K

Quote:
> Can vlookups be used as a formula in the pivot tables calculated
> fields?  I can't seem to get it to work.  Do the calculated fields
> only accept simple formulas?

> Thanks,

> Brent



Sun, 08 Aug 2004 02:50:52 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Calculated Field in Pivot Table - WGT PIVOT.xls (0/1)

2. Calculated Field in Pivot Table - WGT PIVOT.xls (0/1)

3. Summarizing Data Using Pivot Table and VLOOKUP

4. Problem creating a pivot table using another pivot table as source in an excel 2000 macro

5. Calculated field/item in a pivot table.

6. Calculated field values in pivot tables

7. Pivot Table using other Pivot Table for data source

8. Calculated Fields in Pivot Tables

9. Pivot Tables: Running Totals of Calculated Fields

10. Working with Calculated Field in Pivot Tables


 
Powered by phpBB® Forum Software © phpBB Group