Returns a value in a list based upon the index value.

CHOOSE(Index, Amount #1, Amount #2, Amount #3, ...)

Index: determines which amount is to be returned where 1 will return the first amount.

Amount #1, Amount #2, Amount #3, ...: possible values which will be returned based upon the index.

CHOOSE(1, 2, 4, 6) equals 2

CHOOSE(3, 1, 2, 5) equals 5

If the index value is less than 1 or greater than the number of amounts provided, the function will return the value 0.