Lookup fields in Pivot Tables
 

I have a list of various products and use a Pivot Table to total the number
of each different product. I wish put a vlookup inbetween the product and
total colomns to provide a description of the product. This comes from a
different list.Can this be done? I am using Excel 2003. Many thanks

Lookup fields in Pivot Tables
 

NolanC wrote:
I have a list of various products and use a Pivot Table to total the
number of each different product. I wish put a vlookup inbetween the
product and total colomns to provide a description of the product.
This comes from a different list.Can this be done? I am using Excel
2003. Many thanks

Wht not add the VLOOKUP as an additional column in the first list?

Lookup fields in Pivot Tables
 

The list is a schedule of many different products (colomns) that that go to
make up each item (rows), if descriptions were added for each colomn, this
would make the spreadsheet fairly large. I will give it a go and hide those
colomns (with the vlookup). I am new to Pivot Tables and thought there may be
an easier way. Thanks

"Paul Lautman" wrote:

NolanC wrote:
I have a list of various products and use a Pivot Table to total the
number of each different product. I wish put a vlookup inbetween the
product and total colomns to provide a description of the product.
This comes from a different list.Can this be done? I am using Excel
2003. Many thanks

Wht not add the VLOOKUP as an additional column in the first list?