CHOOSE

Given an index and a series of values, it will return the value in the given index.

Syntax

CHOOSE(index, choice1,

[choice2]

)

index

Which choice to return..

choice1

A potential value to return. May reference a cell of individual value

[optional] choice2

A potential value to return. May reference a cell of individual value

More details

CHOOSE returns value ,from the provided ones, in the given index.

CHOOSE(1, A, B) returns A, the choice on index 1

🍪

We use cookies to enhance your user experience and analyze website performance. You can revoke consent anytime. Learn more.