FIELDVALUE

FIELDVALUE(value, field_name)

Returns the value in a particular field from a linked data type.

valueThe company name (for stocks) or region name (for geography).
field_nameThe name (or names) of the fields you want.

REMARKS
* This function was added in Excel 2024.
* This function can be used with the Stocks Linked Data Type.
* This function can be used with the Geography Linked Data Type.
* An alternative to using this function is to use the "cell" notation. If the "field_name" contains a space you must enclose it inside square brackets.
* You can use the STOCKHISTORY function to return historical data about a financial instrument.
* Below cell "C1" contains a Stocks linked data type. To create this type "ABB" into a cell and select Data Tab, Stocks.
* Below cell "C28" contain a Geography linked data type. To create this type "United Kingdom" into a cell and select Data Tab, Geography.
* This function was first released in March 2020.
* For the Microsoft documentation refer to support.microsoft.com

 AB
1MICROSOFT CORPORATION (XNAS:MSFT) 
2=FIELDVALUE(A1, B2) = $468.3552 week high
3=FIELDVALUE(A1, B3) = $366.5052 week low
4=FIELDVALUE(A1, B4) = $0.89Beta
5=FIELDVALUE(A1, B5) = -$3.33Change
6=FIELDVALUE(A1, B6) = -$0.01Change (%)
7=FIELDVALUE(A1, B7) = USDCurrency
8=FIELDVALUE(C1,B7) = [full description]Description
9=FIELDVALUE(A1, B9) = 228,000_ Employees
10=FIELDVALUE(A1, B10) = XNASExchange abbreviation
11=FIELDVALUE(C1,B10) = 1 Microsoft WayHeadquarters
12=FIELDVALUE(A1, B12) = $426.73High
13=FIELDVALUE(A1, B13) = Software & IT ServicesIndustry
14=FIELDVALUE(A1, B14) = StockInstrument type
15=FIELDVALUE(A1, B15) = 12:59:45 AMLast trade time
16=FIELDVALUE(A1, B16) = $420.66Low
17=FIELDVALUE(A1, B17) = 3,133,802,341,500_ Market cap
18=FIELDVALUE(A1, B18) = MICROSOFT CORPORATIONName
19=FIELDVALUE(A1, B19) = MICROSOFT CORPORATIONOfficial name
20=FIELDVALUE(A1, B20) = $426.10Open
21=FIELDVALUE(A1, B21) = $34.79P/E
22=FIELDVALUE(A1, B22) = $424.83Previous close
23=FIELDVALUE(A1, B23) = $421.50Price
24=FIELDVALUE(A1, B24) = 7,434,881,000_ Shares outstanding
25=FIELDVALUE(A1, B25) = MSFTTicker symbol
26=FIELDVALUE(A1, B26) = 13,246,509_ Volume
27=FIELDVALUE(A1, B27) = 21,489,228_ Volume average
28=FIELDVALUE(A1, B28) = 1993_ Year incorporated
29United Kingdom 
30=FIELDVALUE(A29, B30) = LondonCapital/major city
31=FIELDVALUE(A29, B31) = EnglishOfficial language
32=FIELDVALUE(A29, B32) = 66,834,405_ Population
33=FIELDVALUE(A29, B33) = #FIELD!Invalid Field

1 - What is the 52 week high for this particular Stocks linked data type.
2 - What is the 52 week low for this particular Stocks linked data type.
8 - What is the number of employees for this particular Stock linked data type.
28 - What is the capital city of this particular Geography linked data type.
29 - What is the official language of this particular Geography linked data type.
30 - What is the population of this particular Geography linked data type.
31 - If the fieldname is not valid then, #FIELD! is returned.

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top