GET

The GET function can be used to select a value from a specified position in a list.

Syntax

GET(list, index)

Arguments

list – List of values to check. Required.

index – The position of the value in the list. Required.

Return value

A single value

Example

GET([2,5,8,3,7,5], 3)
//Returns 8

In the example shown below, we take the store 1 sales for the Central region and the store 2 sales for all the other regions.

GET function