UPDATE_ROW

Updates a row in an existing frame. Uses search expression to select a single row in target frame.

Syntax

UPDATE_ROW(targetFrame, searchExpr, frameOrRangeToUpdateWith)

• targetFrame - Target Frame.

• searchExpr - Search Expression.

• frameOrRangeToUpdateWith - Frame/range to update with.

Sample Usage

UPDATE_ROW(C1, "@number = 2", C2)
UPDATE_ROW(C1, D1, A6:B6)

Return Value

• TRUE if function modified the targetFrame.

• FALSE otherwise.

Notes

In order for UPDATE_ROW to work, the first argument targetFrame must be a FRAME.

See Also