Cellgrids Cellgrids
Home › Excel formulas › Lookup and Reference › GETPIVOTDATA

GETPIVOTDATA Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

GETPIVOTDATA is an Excel Lookup & Reference function. Pulls a specific value out of a PivotTable.

GETPIVOTDATA syntax

=GETPIVOTDATA(data_field, pivot_table, [field1, item1], ...)

Arguments

When to use GETPIVOTDATA

GETPIVOTDATA is used to pull matching data from one part of a workbook into another.

Practice GETPIVOTDATA online, free

Open the live Excel-style spreadsheet and try GETPIVOTDATA yourself. No Excel install or sign-up needed to start.

Practice GETPIVOTDATA now →

More Lookup & Reference functions

Frequently asked questions

What does the GETPIVOTDATA function do in Excel?

Pulls a specific value out of a PivotTable.

What is the syntax of GETPIVOTDATA in Excel?

The syntax is =GETPIVOTDATA(data_field, pivot_table, [field1, item1], ...). data_field: The name of the value field to retrieve; pivot_table: A reference to a cell within the PivotTable; field1: The name of a field to filter by (optional); item1: The item within that field to filter to (optional).

Where can I practice GETPIVOTDATA online for free?

Open the free live spreadsheet on Cellgrids and try GETPIVOTDATA yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts