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.
| Formula | Excel shows | Case |
|---|---|---|
=FIELDVALUE(5,"x") | #FIELD! | Number |
=FIELDVALUE(Items!B2,"Population") | #FIELD! | Plain text cell, not a data type |
The Items sheet these formulas read
B
1
Item
2
Boxer cartridge
Items
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 .