The CHOOSE Function
The CHOOSE function returns a value from an array of values, that corresponds to a specific position in that array.
The CHOOSE function returns a value from an array of values, that corresponds to a specific position in that array.
Probably the easiest to understand lookup function is the CHOOSE function. It returns a value from an array of values, that corresponds to a specific position in that array.