lookup values in a pivot table

[Reillc01]

What is the syntax to lookup values in a pivot table? My pivot table has the columns product, monday, tuesday, wednesday, etc. Rows are product name and sum of sales by weekday.


I can use vlookup to search the cells as static references. There seems like there should be a a way to search as though it were a table with column headings [#headers} or something similar. Any thoughts?

 

[Luke M]

Check out the GETPIVOTDATA function.

Basic syntax:

GETPIVOTDATA(data_field,pivot_table,field1,item1,field2,item2,...)


Basically, you define which pivot table you want to look at and which data field, and then you define what you want to look up by defining the field and corresponding item. Usually, if you type "=" and then click in a PivotTable, this formula will write itself. Otherwise, check out the help file for further detail.

 

[Reillc01]

Awesome! thanks.