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 9 months ago