Updates or inserts data from ranges or {data} cells into a destination range.

Parameter List


The range or {data} cell from where data is to be inserted or updated in the destination range. The first row of data will be used as a header of the destination range. For example: A1:E4 or A2. Pro tip: If the headers are in a column instead of a row of a range, use RANGE2JSON to create a {data} cell first.

[optional] keys

Provide an array formatted as '["key", ...]' or {["key1", ...]}. If it has only one key, you can use key1. When using ranges the first row identifies the available keys. If absent the first element from the array or range is used.

[optional] destination

The cell or range corresponding to the header of table where to insert or update the data. For example: A15:B15.


UPDATE(A2:C2, A2, A5:C5) returns "Update.... " , and two rows are inserted below row 5, one with A3:C3, and the other with A4:C4.