CHOOSE Formula in Excel

 

What Does It Do?

This function picks from a list of options based upon an Index value given to by the user.

Syntax

=CHOOSE(UserValue, Item1, Item2, Item3 through to Item29)

Formatting

No special formatting is required.

Example

The following table was used to calculate the medals for athletes taking part in a race.

The Time for each athlete is entered.

The =RANK() function calculates the finishing position of each athlete.

The =CHOOSE() then allocates the correct medal.

The =IF() has been used to filter out any positions above 3, as this would cause

the error of #VALUE to appear, due to the fact the =CHOOSE() has only three items in it.