OBJECT
Creates an object that can be queried by key. Arguments are passed in as either an array of key-value pairs or as paired key and value parameters.
Syntax
=OBJECT(key1, value1, key2, value2, ...)
=OBJECT(keyvalues)
Arguments
| Argument | Type | Description |
|---|---|---|
| keyN | String | The key for the key-value pair. If the key is a non-string it will be converted to a string type |
| valueN | Any | The value for the specified key. Values can be different types |
| keyvalues | Array | An array of key-value pairs. Each element in the array should be an array with two values, the first representing the key and the second representing the value. |
Examples
=OBJECT("A", 2)→{"A": 1}
Creates an object consisting of the key "A" which maps to the value 1
=OBJECT("A", 1, "B", 2)→{"A": 1, "B": 2}
Creates an object consisting of the key "A" which maps to the value 1, and the key "B" which maps to the value 2.
=OBJECT(ARRAY("A", 1), ARRAY("B", 2))→{"A": 1, "B": 2}
Creates an object consisting of the key "A" which maps to the value 1, and the key "B" which maps to the value 2
Updated 10 months ago