ExcelBanter - Index & Match on Pivot Table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Index & Match on Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/21394-index-match-pivot-table.html)

Nelson

Index & Match on Pivot Table

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

Debra Dalgleish

Nelson wrote:
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

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

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.

Nelson wrote:
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

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

All times are GMT +1. The time now is 11:26 PM.