Index & Match on Pivot Table

N

Nelson

Hi,

I'm using Office 97 - and was wondering if there is a way to do an Index
(Match), (Match) type function on a Pivot Table?

I've tried it - but I get a #value error. Does anyone know a way around
this?

Nelson
 
D

Debra Dalgleish

Nelson said:
Hi,

I'm using Office 97 - and was wondering if there is a way to do an Index
(Match), (Match) type function on a Pivot Table?

I've tried it - but I get a #value error. Does anyone know a way around
this?

Nelson
Click to expand...
 
D

Debra Dalgleish

You can use the GETPIVOTDATA function to extract data from the pivot
table. For example:

=GETPIVOTDATA($A$5,"Ontario")

Look in Excel's Help for examples.
 
Top