Lookup fields in Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
NolanC said:
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
Click to expand...

Wht not add the VLOOKUP as an additional column in the first list?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table multiple filters 2
Excel 2010 Pivot Table 2
Pivot table automation 1
Automatically Update a Pivot Table Field Used as Column / Row 1
Pivot Page field filter based on cell value 6
Get visible pivot table items 4
Counting number of items excluding duplicates. 1
Question on pivot tables 1

Back
Top