This function retrieves field data from linked data types.
FIELDVALUE(value, field_name)
This function has these arguments:
| Argument | Description |
|---|---|
| value | Function returns all matching fields(s) from the linked data type specified in the value argument. |
| field_name |
The name or names of the fields you would like to extract from the linked data type. |
If you try to retrieve data from a non-existent data type field, the FIELDVALUE function will return the #FIELD! error.
=FIELDVALUE(A1,"Product")
=FIELDVALUE(A2,"Price")
