Reference
No results for 'undefined'
    Powered by Algolia

    UPDATE_ROW

    Updates a row in an existing frame. Uses searchExpr to select a single row in TargetFrame.

    Syntax

    =UPDATE_ROW(Target Frame, Search Expression, Frame/range to update with)
    This function is always Lazy

    Parameters

    1. Target Frame
      • Type: Frame
      • Description: Target Frame
    2. Search Expression
    3. Frame/range to update with
      • Type: Frame
      • Description: Frame/range to update with

    Returns

    • Type: Boolean
    • Description: Returns TRUE if successful, FALSE otherwise.

    Example

    =UPDATE_ROW(A1, @id = 5, A2)

    See Also

    Contents