- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
-
Functions D to G
- DATE
- DATEDIF
- DATEVALUE
- DAVERAGE
- DAY
- DAYS
- DAYS360
- DB
- DBCS
- DCOUNT
- DCOUNTA
- DDB
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DECIMAL
- DEGREES
- DELTA
- DEVSQ
- DGET
- DISC
- DMAX
- DMIN
- DOLLAR
- DOLLARDE
- DOLLARFR
- DPRODUCT
- DROP
- DSTDEV
- DSTDEVP
- DSUM
- DURATION
- DVAR
- DVARP
- EDATE
- EFFECT
- ENCODEURL
- EOMONTH
- ERF
- ERF.PRECISE
- ERFC
- ERFC.PRECISE
- ERROR.TYPE
- ERRORTYPE
- EURO
- EUROCONVERT
- EVALUATE
- EVEN
- EXACT
- EXP
- EXPAND
- EXPON.DIST
- EXPONDIST
- F.DIST
- F.DIST.RT
- F.INV
- F.INV.RT
- F.TEST
- FACT
- FACTDOUBLE
- FALSE
- FDIST
- FIELDVALUE
- FILTER
- FILTERXML
- FIND
- FINDB
- FINV
- FISHER
- FISHERINV
- FIXED
- FLOOR
- FLOOR.MATH
- FLOOR.PRECISE
- FORECAST
- FORECAST.LINEAR
- FORECAST.ETS
- FORECAST.ETS.CONFINT
- FORECAST.ETS.SEASONALITY
- FORECAST.ETS.STAT
- FORMULATEXT
- FREQUENCY
- FTEST
- FV
- FVSCHEDULE
- GAMMA
- GAMMA.DIST
- GAMMA.INV
- GAMMADIST
- GAMMAINV
- GAMMALN
- GAMMALN.PRECISE
- GAUGEKPISPARKLINE
- GAUSS
- GCD
- GEOMEAN
- GESTEP
- GROWTH
- Functions H to L
- Functions M to Q
- Functions R to S
- Functions T to Z
FIELDVALUE
This function retrieves field data from linked data types.
Syntax
FIELDVALUE(value, field_name)
Arguments
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. |
Remarks
If you try to retrieve data from a non-existent data type field, the FIELDVALUE function will return the #FIELD! error.
Examples
=FIELDVALUE(A1,"Product")
=FIELDVALUE(A2,"Price")