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.
Updated 3 months ago