I am trying to pull information that is summarized in a pivot table and
return it in a report. The returned info will be dependent on the leftmost
column of the report and the month that the report is being pulled for. The
pivot table has each of these pieces. For example

Code Items
M300
M301
M302

I want to return items based on the code, as well as the month (say January
2006)....is there a matrix type function that will do this? (I'm envisioning
something like Lookup(Code|Month) with reference to the pivot table....hope
someone can help!!! Thanks