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

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

ArgumentTypeDescription
collectionStringThe name of the collection to reference
keyString(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.