Summary

The Excel CHOOSE work restores an incentive from a rundown utilizing a given position or record. For instance, CHOOSE(2,"red","blue","green") returns "blue", since blue is the second esteem recorded after the list number. The qualities gave to CHOOSE can incorporate references.

Purpose

Get an incentive from a rundown in light of position

Return value

The incentive at the given position.

Syntax

=CHOOSE (index_num, value1, [value2], ...)

Contentions

index_num - The incentive to pick. A number in the vicinity of 1 and 254.

value1 - The primary incentive from which to pick.

value2 - [optional] The second an incentive from which to pick.

Use notes

Pick can deal with up to 254 esteems. Index_num returns an esteem in view of it's position in the rundown. For instance, if index_num is 2, value2 is returned.

Qualities can likewise be references. For instance, the address A1, or the reaches A1:10 or B2:B15 can be provided as qualities.
                           Example Of Choose Formua