# Excel FIELDVALUE function

## Summary

The FIELDVALUE function in Excel is designed for retrieving specific field data from linked data types like Stocks or Geography. It’s part of the Lookup & Reference family and is particularly useful for extracting detailed information from complex data types. FIELDVALUE is ideal for creating conditional calculations based on linked data types, offering a method to dynamically pull data from sources like stock prices or geographical information.
##### Syntax
```				```
```
```
• value: The cell reference or linked data type from which you want to retrieve information.
• field_name: The name of the field you wish to extract from the linked data type.
##### Return value
Returns the specified field(s) from the linked data type.

## How to use

To use FIELDVALUE, specify the cell reference containing the linked data type in the value argument and the field name you want to extract in the field_name argument. The function is particularly effective in scenarios where conditional calculations are based on dynamic, external data, like stock market feeds or geographic databases.

## Examples

##### Simple FIELDVALUE
Extracting Stock Price:
```				```
=FIELDVALUE(A2, "Price")

```
```
Assuming A2 contains a stock data type for a company, this formula extracts the current stock price.
##### FIELDVALUE with Error Handling
Conditional Retrieval with Error Check:
```				```
=IFERROR(FIELDVALUE(\$A2, B\$1), "")

```
```
This formula retrieves the price from the data type in A2, but if A2 doesn’t contain a company name or valid data, it returns an empty string.
##### FIELDVALUE with Dynamic Field Name
Dynamic Field Extraction:
```				```
=FIELDVALUE(A2, B1)
```
```
Assume B1 contains the text “Price”. This formula dynamically extracts the price based on the field name specified in B1.

• The function can be used to reference worksheet cells for the `field_name` argument, allowing for more dynamic and adaptable formulas.