The GET function can be used to select a value from a specified position in a list.
GET(list, index)
list – List of values to check. Required.
index – The position of the value in the list. Required.
A single value
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.
Last updated 4 days ago
Was this helpful?