FIELDLOOKUP
Uses a reference key and the collection name to find a data property.
Syntax
=FIELDLOOKUP(collection, data, key)
Arguments
Argument | Type | Description |
---|---|---|
collection | String | The name of the collection to reference |
data | String | The shape data property to reference |
key | String | The key value to find within the data |
Examples
=FIELDLOOKUP("Sheet1", "Employee Name", "123")
→ "John Doe"
Gets the employee name data property for the "Sheet1" collection, where the reference key is "123"
Updated 8 months ago