CHOOSE Function
CHOOSE () is a lookup and reference function which takes 'index_num, value' as argument and returns a value from the given list of values.
Formula:
=CHOOSE (index_num, value1, value2.)
In the above syntax, the argument 'index_num' refers to the recently chosen value
The argument 'value 1, value 2' denotes the values among 1 to 254..
Video Tutorial:
Let us view how the CHOOSE function can able to reproduce the value with the help of below video.
