Array

Description of formula:
Creates an array of elements from parameters. The parameters can be passed as single values, arrays or cell ranges. All values should be of the same type.

Syntax:
array(element, ...)

Parameters:

element

(type: any) (multiple parameter) Values in array

Returned type:

array of values of any type

Examples:
=array(1,2,3,4)
=array('first element', 'second element')
=array(A,B,C)
=array(B3, C1+3,11)

Note: If an array is used in a lookup condition, it can contain a maximum of 1000 elements. If the limit is exceeded, the user will receive an error message.