The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. You could create a copy of the
pivot table, and fill the blanks, to do the lookup. Perhaps you could
use INDEX/MATCH formulas to work with the data in the pivot table, but
would have problems if the layout changed.

Why don't you want to use GetPivotData?

Alastair Scott wrote:
I want to perform lookups ona pivot table without using the gETPIVOTDATA
function. Is it possible to show a decsription against each line of the pivot
table, instead of blank spaces? e.g.

Field 1 Field 2 Data 1
Field 1 Field 2 Data 2
Field 1 Field 2 Data 3
Field 1 Field 2 Data 4



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html