Using Vlookup in Pivot Table Calculated Fields
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.
Technology 4 U W98 XL2K
> 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?