You can use the GETPIVOTDATA function to extract data from the pivot
table. There are instructions in Excel's Help, and he

http://www.contextures.com/xlPivot06.html

David A. wrote:
I have a vlookup that is searching a Pivot table. The proble is that every
morning the pivot table updates and adds a new column of data. This makes my
vlookup error out because its looking in the wrong column. How do I tell my
vlookup to look for a column with a heading OR tell it to look in the last
column with data in it?

Thanx,


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html