LOOKUP / COLLECTION

Finds data from a collection using a reference key and returns an array of all the data associated with that reference key.

Syntax

=LOOKUP(collection, key)

Arguments

Argument	Type	Description
collection	String	The name of the collection to reference
key	String	(Optional) The reference key for the collection

Examples

=LOOKUP("Sheet1", "123") → ["123", "Steve Rogers", "Captain America"]
Gets all values for a row in the "Sheet1" collection.

=LOOKUP("Sheet1", "123")."Name" → "Steve Rogers"
Gets the Name field for the row with the key "123" in the "Sheet1" collection.

=LOOKUP("Sheet1")."Name" → ["Steve Rogers", "Tony Stark", "Bruce Banner"]
Gets the Name field for all rows in the "Sheet1" collection.