CHOOSE(N, <List>)

 

Description

This function returns the Nth argument from the argument list, starting with an index of 0.

 

Parameters

 

N

A numeric value that should be less than or equal to the number of items in <List> - 1.

 

<List>

Any combination of numbers, strings, or cell addresses separated by commas.

 

Examples

 

CHOOSE(2, D1, C22, F5, K1) = 54

Where F5= 54.

 

CHOOSE(1, A9, D23, G12) = "Peaches"

Where D23 = "Peaches".

 

CHOOSE(3, "nuts", "rings", "bolts", "fittings") = "fittings"

 

SUM(CHOOSE(A1B1, B1:B10, A1:A10))

Sums either column A or column B.