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