Practice free

FIELDVALUE function

FIELDVALUE extracts one field from a linked data type cell, such as Stocks or Geography, and returns it as a regular value. It needs an online connection, and plain text gives an error.

Example

=FIELDVALUE(A1,"Population")

Expected result: n/a Not yet checked in desktop Excel

Syntax

FIELDVALUE(value, field_name)

value (required)
A cell holding a linked data type such as Stocks or Geography.
field_name (required)
The field to pull out, such as "Population".

Returns: The requested field from the linked data type.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=FIELDVALUE(5,"x") #FIELD! Number
=FIELDVALUE(Items!B2,"Population") #FIELD! Plain text cell, not a data type

The Items sheet these formulas read

Watch out for

  • Needs a cell converted to a data type; plain text gives #FIELD!.
  • Field names must match exactly.

Where it works

Excel
FIELDVALUE is only in Excel for Microsoft 365 and Excel for the web. Needs 365 with linked data types (online connection).
Google Sheets
No direct equivalent. Sheets uses smart chips and GOOGLEFINANCE instead of linked data types.

Part of Lookup and reference functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .