Reference
No results for 'undefined'
    Powered by Algolia

    UPSERT_ROW

    Updates a row or inserts a new row (after last row in TargetFrame).

    Syntax

    =UPSERT_ROW(Target Frame, Search Expression, Frame/range to upsert)
    This function is always Lazy

    Parameters

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

    Returns

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

    Example

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

    See Also

    Contents