These docs are for v1.0. Click to read the latest docs for v1.2.

FIELDLOOKUP

Uses a reference key and the collection name to find a data property.

Syntax

=FIELDLOOKUP(collection, data, key)

Arguments

ArgumentTypeDescription
collectionStringThe name of the collection to reference
dataStringThe shape data property to reference
keyStringThe 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"