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.

Learn MS Excel


Ask Questions

Ask Question