Lookup & Reference

GETPIVOTDATA function: pull specific totals from a PivotTable by field name

Retrieve aggregated PivotTable values by field and item pairs with GETPIVOTDATA so layout refreshes do not break report links.

Open spreadsheet ↗

Structured summary lookups by field and item pair

GETPIVOTDATA(data_field, pivot_table, [field1, item1, ...]) extracts a measure by naming the data field and one or more field/item filter pairs rather than hardcoding fragile row and column coordinates.

If a requested field or item does not exist in the summary report, GETPIVOTDATA returns #REF!.

=GETPIVOTDATA("Revenue", A1:C5, "Region", E2)

Try the example

Use the original values or change them to test your understanding.