#FIELD! appears when you reference a field (e.g. .Price) on a linked data type — like Stocks or Geography — that doesn't exist or isn't available for that record.
Pick a valid field
Click the data type's card icon to see which fields are available, then reference one of those.
Handle missing values
Wrap the reference in IFERROR to handle records that lack the field.
You asked a linked data type for a field it doesn't have. Check the available fields via the card icon.